select user_id
,count(visit_time) visit_nums
from visit_tb
where date_format(visit_time,'%Y-%m-%d') = '2022-09-02' and user_id in 
(
	select user_id
	from order_tb
	where date_format(order_time,'%Y-%m-%d')  = '2022-09-02'
)
group by 1
order by visit_nums desc