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