下面的sql 修改为每日人数select user_id DATE_FORMATbrcreated_at Y-m-d as day from box_draw_record br join box as b on brbox_id = bid where is_need_quota = 1 group by dayuser_id order by day desc;

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;