按月
SELECT DATE_FORMAT( create_time, '%Y%m' ) AS time FROM xxx WHERE DATE_FORMAT( a.create_time, '%Y' ) = 2023 GROUP BY DATE_FORMAT( create_time, '%Y%m' )
按日
SELECT DATE_FORMAT( create_time, '%Y%m%d' ) AS time FROM xxx WHERE DATE_FORMAT( a.create_time, '%Y%m' ) = 202304 GROUP BY DATE_FORMAT( create_time, '%Y%m%d' )