select 'male',count(profile)
from user_submit
where profile like '%,male'
union
select 'female',count(profile)
from user_submit
where profile like '%female'