SQL 查询语句：统计每日用户人数

select DATE_FORMAT(br.created_at, '%Y-%m-%d') as day, count(distinct user_id) as daily_count from box_draw_record br join box as b on br.box_id = b.id where is_need_quota = 1 group by day order by day desc;