SELECT 
substring_index(profile, ',', -1) as gender,
COUNT(*) AS number 
FROM user_submit 
group by gender;