需要用到substring_index(str, delim, count)

str:表示要处理的字符串 delim:表示要分割的字符 count:正数表示从左往右数的第count个数，负数表示从右往左数的第count个数

select 
substring_index(profile, ',', -1) as gender,
count(*) as number
from user_submit
group by gender;