with t as (
    select user_id, date(order_time) as order_date, count(1) as order_nums
    from order_tb
    group by date(order_time), user_id
    having count(1)>1
)
select order_date, t.user_id, order_nums, vip
from t join uservip_tb u on t.user_id=u.user_id