select u.name,pn.date, pn.number
from (select user_id,date, @r := IF(@b = user_id, @r + number, number) AS number, @b := user_id
from passing_number,
(select @b := NULL ,@r=0) a
order by user_id, date asc) pn join user u on u.id=pn.user_id order by pn.date asc , u.name asc