select
    vt.user_id as user_id,
    count(vt.user_id) as visit_nums
from
    visit_tb as vt
where
    vt.user_id in (
        select distinct
            ot.user_id
        from
            order_tb ot
        where
            day (order_time) = 02
    )
    and day (visit_time) = 02
group by
    user_id
order by
    visit_nums desc