mysql 当日小计 总计sql

SELECT
    create_time,
    total1 as "小计",
    @total := @total + total1 AS "总计"
FROM
    (
        SELECT
            date(create_time) AS create_time,
            sum(1) AS total1
        FROM
            sys_wx_user
        GROUP BY
            date(create_time)
    ) AS temp,
    (SELECT @total := 0) AS T1
ORDER BY
    create_time;