mysql 通过时间戳查询每天的数据量

select FROM_UNIXTIME(reg_time,'%Y-%m-%d')as date,COUNT(*) 
FROM wd_member 
where phone != '' and reg_time != ''
GROUP BY FROM_UNIXTIME(reg_time,'%Y-%m-%d');