SQL对所有行进行计数，而不是对单个行进行计数

我有一条SQL语句，该语句从数据库请求数据。

SELECT ID, To, Poster, Content, Time, ifnull(Aura,0) as Aura FROM ( SELECT * FROM ( SELECT DISTINCT * FROM messages m INNER JOIN ( SELECT Friend2 as Friend FROM friends WHERE Friend1 = '1' UNION ALL SELECT Friend1 as Friend FROM friends WHERE Friend2 = '1' ) friends ON m.Poster = friends.Friend UNION ALL SELECT DISTINCT , '1' FROM messages where Poster='1' ) var LEFT JOIN ( select ID as AuraID, Status as AuraStatus, count() as Aura from messages_aura ) aura ON (var.Poster = aura.AuraID AND var.ID = aura.AuraStatus) ) final

GROUP BY ID, Poster ORDER BY Time DESC LIMIT 10 这是我的messages_aura桌子布置。这表明ID，Status和UserID。

这是上述语句的输出。

（ID以上屏幕截图中的指的是Poster下面，Status而以上屏幕截图中的指的是ID下面）

该语句应使最下面一行的Aura计数为1，最上面一行的Aura计数为2。怎么了？