select
        a.order_date,
        a.user_id,
        a.order_nums,
        utb.vip
from (
    select
        user_id,
        date(order_time) as order_date,
        count(*) as order_nums
    from 
            order_tb
    group by
            date(order_time),
            user_id
    having
            count(*) > 1
)a
inner join 
        uservip_tb as utb
on 
        a.user_id = utb.user_id