select
    t1.name as u_n,
    t2.date as date,
    coalesce(t2.num, 0) as ps_num
from user t1

inner join
    (select
        user_id,
        date,
        sum(number) over(partition by user_id order by date asc)as num
    from passing_number) t2
on t1.id=t2.user_id

order by t2.date asc,t1.name asc