select name,date,sum(number) over(partition by user_id order by date) 
from passing_number 
left join user u
on u.id=user_id 
order by date,name

使用窗口函数就很容易实现，根据题意,login表根本不用管他