SELECT u.name u_n,DATE, (SELECT SUM(number) FROM passing_number p1 WHERE p1.date <= p2.date AND p1.user_id = p2.user_id) ps_num FROM passing_number p2 LEFT JOIN user u ON u.id=p2.user_id ORDER BY DATE, u_n ASC