mysql获取 每天时间戳_mysql – 根据给定的时间戳获取每天的总数

我有一个简单的表：

user | timestamp

===================

Foo | 1440358805

Bar | 1440558805

BarFoo | 1440559805

FooBar | 1440758805

我想获得每天总用户数的观点：

date | total

===================

...

2015-08-23 | 1 //Foo

2015-08-24 | 1

2015-08-25 | 1

2015-08-26 | 3 //+Bar +BarFoo

2015-08-27 | 3

2015-08-28 | 4 //+FooBar

...

我现在拥有的是

SELECT From_unixtime(a.timestamp, '%Y-%m-%d') AS date,

Count(From_unixtime(a.timestamp, '%Y-%m-%d')) AS total

FROM thetable AS a

GROUP BY From_unixtime(a.timestamp, '%Y-%m-%d')

ORDER BY a.timestamp ASC

它只计算某一天的用户：

date | total

===================

2015-08-23 | 1 //Foo

2015-08-26 | 2 //Bar +BarFoo

2015-08-28 | 1 //FooBar

编辑

@ splash58的解决方案返回以下结果：

date | @t:=coalesce(total, @t)

==================================

2015-08-23 | 1

2015-08-26 | 3

2015-08-28 | 4

2015-08-21 | 4

2015-08-22 | 4

2015-08-24 | 4

2015-08-25 | 4

2015-08-27 | 4

2015-08-29 | 4

2015-08-30 | 4