SQL:SELECT count(*) AS 'count',city_id FROM `wt_user_follow` group BY city_id order by count desc 表如下: 结果如下: