分组同时统计数量

SELECT province,count(*) AS counts from z_pv_count GROUP BY province;