with
    t as (
        select distinct
            date (order_time) as order_date,
            user_id,
            count(order_id) over (
                partition by
                    date (order_time),
                    user_id
            ) as order_nums,
            vip
        from
            order_tb
            left join uservip_tb using (user_id)
    )

select t.* from t
where order_nums >1
order by order_nums desc