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