每天 selectCOUNT(1) AS total,date_format(create_time, %Y-%m-%d) AS days
fromwx_user
group bydays
order by days desc 每周 selectCOUNT(1) AS total,week (create_time) AS weeks
fromwx_user
group byweeks
order by weeks desc 每月 selectCOUNT(1) AS total,month (…