select user.name,b.date,b.ps_num
from 
(select pn.user_id,pn.date,sum(pn2.number) as ps_num
from passing_number pn inner join passing_number pn2 on pn.user_id==pn2.user_id and pn.date>=pn2.date
group by pn.user_id,pn.date) as b left join user on b.user_id==user.id
order by b.date,user.name