请在你的 MySQL 数据库中运行以下 SQL 查询:
SELECT
DATE_FORMAT(date, '%W') AS week_day,
COUNT(*) AS order_count
FROM
orders
WHERE
user_id = [input_user_id]
AND date >= DATE_SUB(NOW(), INTERVAL 1 WEEK)
GROUP BY
week_day
ORDER BY
week_day;
这将会统计本周中指定用户的上单量,并按星期一到星期天的顺序