按日期（天/日）分组统计数量

select DATE(FROM_UNIXTIME(create_time)) as date, COUNT(*) as count FROM xxx.aa_user GROUP BY date ORDER BY date; --注：这个在神通数据库里会显示时间

SELECT SUBSTR(FROM_UNIXTIME(create_time), 1, 10) AS date, COUNT(*) AS count FROM xxx.aa_user GROUP BY date ORDER BY date;