select v.user_id, count(distinct visit_time) as visit_nums
from order_tb as o join visit_tb as v 
on o.user_id = v.user_id and date(visit_time) = '2022-09-02' and date(visit_time) = '2022-09-02' and date(order_time) = '2022-09-02'
group by v.user_id
order by visit_nums desc;