统计每日用户数

select from_unixtime(create_time, "%Y-%m-%d") as t, count(distinct(id)), count(*) from user group by t;