获取当天的注册人数

SELECT COUNT(*) AS '注册人数', CURDATE() AS '当前日期'
FROM users
WHERE created_at between CURDATE() AND  DATE_ADD(CURDATE(), INTERVAL 1 DAY);

 SELECT DATE_FORMAT(created_at, "%Y-%m-%d" ) AS time, COUNT(*) AS total FROM users GROUP BY DATE_FORMAT(created_at, "%Y-%m-%d") ORDER BY created_at DESC;