PHP MySQL根据年，月，日，时间日期等条件分组统计数据

SELECT 
uid,
suid,
DATE_FORMAT(FROM_UNIXTIME(createtime), '%Y-%m-%d') days,
COUNT(id) COUNT 
FROM  fm_retail_log.industry_amount_cash_log 
WHERE createtime >=1719763200 
GROUP BY days,uid,suid;