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