SELECT
    SUBSTRING_INDEX(profile, ',', -1) gender,
    COUNT(*) number
FROM
    user_submit
GROUP BY
    gender;