我知道SQL语法很强大，不过我也不是很精通，针对你的需求，我提供如下参考意见。

select a.uid,a.money,c.total_money from (select b.uid,sum(b.money) as total_money from leshi_deal_invest as b group by b.uid) as c 
right join leshi_deal_invest as a 
on a.uid = c.uid;

select b.uid, b.money, a.total from (select uid, sum(money) as total from test group by uid) as a, test as b where a.uid = b.uid

够懒的