select name,count(*) as 人次 from 表 group by name order by 人次 desc

select new,count(*) group by new order by count(*) desc limit 1 大致的思路，sql我没测试，你自己改改