substring_index(profile,",",-1) 截取最后一个逗号后字符串
count * 也可以
需要记得分组
SELECT substring_index(profile,",",-1) gender,
COUNT(device_id) number
FROM user_submit
GROUP BY gender