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

substring_index(字段名称,'符号',取的字符串个数):个数为整数向前取字段，个数为负数向后取字符串。