SELECT
d.*, @total :=@total + addition AS total
FROM
(
SELECT
TRUNCATE (day_id, 0) AS date,
sum(new_user) AS addition,
sum(active_user) AS active
FROM
(SELECT @total := 0) t,
`dmp_new_active_users_stat` d
WHERE
TRUNCATE (day_id, 0) >= 20181211
AND TRUNCATE (day_id, 0) <= 20181319
GROUP BY
date
ORDER BY
date
) d