****-- --以下都可以****
select count(*) as '数量',date_format(create_time,'%m') as month from `user` group by month;
select count(*) as '数量',mid(create_time,1,7) as month from `user` where YEAR(create_time)=2020 group by month;
select count(*) as '数量',month(create_time) as month from `user` where year(create_time)=2020 group by monthname(create_time);