SELECT
FROM_UNIXTIME(create_time,'%Y-%m-%d') AS 时间,
count(*) AS 新增人数
FROM
table
WHERE
FROM_UNIXTIME(create_time, '%Y-%m-%d') > '2021-03-01'
and
FROM_UNIXTIME(create_time, '%Y-%m-%d') < '2021-04-02'
GROUP BY
FROM_UNIXTIME(create_time,'%Y-%m-%d')
ORDER BY
FROM_UNIXTIME(create_time,'%Y-%m-%d');
搞定
