SELECT
DATE_FORMAT(regist_time, '%Y-%m') as regist_time,
COUNT(*) as count
FROM
users
GROUP BY
DATE_FORMAT(regist_time, '%Y%m');
SELECT
DATE_FORMAT(regist_time, '%Y-%m') as regist_time,
COUNT(*) as count
FROM
users
GROUP BY
DATE_FORMAT(regist_time, '%Y%m');