with t1 as (
    select distinct user_id
    from order_tb
    where date_format(order_time, '%Y-%m-%d')='2022-09-02'
), t2 as (
    select user_id
    from visit_tb
    where date_format(visit_time, '%Y-%m-%d')='2022-09-02'
)
select t1.user_id, count(1) as visit_nums
from t1 join t2 on t1.user_id=t2.user_id
group by t1.user_id
order by visit_nums desc