mysql GROUP BY count(*) 数据库按照月份分组在同一张表中 计算数量

SELECT
count(t.counts)
FROM
(
SELECT
count(*) counts
FROM
表名 where 
and  user_id = #{user_id}
GROUP BY
DATE_FORMAT(create_time, '%Y-%m')
) t