嵌套使用substring_index，先提取出后2段字符，包含age，再次使用substring_index提取第一个字符age

select lower(substring_index(substring_index(profile,",",-2),",",1)) as age,count(*) as number
from user_submit
group by age
;