SELECT DATE_FORMAT(regist_time, '%Y-%m') as regist_time, COUNT(*) as count FROM users GROUP BY DATE_FORMAT(regist_time, '%Y%m');MySQLで月別、日別、時間、曜日別にレコード数を集計する方法 - おおらかにいこう