Mysql按天统计

时间戳

select FROM_UNIXTIME(yourtime,'%Y%m%d') as days，uid from yourtable
group by days

Datetime

select DATE_FORMAT(yourtime,'%Y%m%d') as days，uid from yourtable
group by days