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

暴力解法：直接把两种都查出来，然后union一下