求三张表联查的MYSQL语句

问题遇到的现象和发生背景

MYSQL 表 USER ,SUM,MONEY;

USER 表结构为 UID NAME；

id | UID | NAME
1 | 1 |张三
2 | 2 |李四
3 | 3 |王五

JIFEN表结构为 UID USER SUM0;
id | UID | USER | SUM0
1 | 1 |张三 |5
2 | 1 |张三 |2
3 | 2 |李四 |5
4 | 2 |李四 |5
5 | 3 |王五 |2
6 | 3 |王五 |2

MONEY表结构为 UID USER SUM1;
id | UID | USER | SUM 1
1 | 1 |张三 |6
2 | 1 |张三 |7
3 | 2 |李四 |2
4 | 2 |李四 |7
5 | 3 |王五 |6
6 | 3 |王五 |6

希望查询结果为
UID | NAME |SUM0 |SUM1
1 |张三 | 7 | 13
2 |李四 | 10 | 9
3 |王五 | 4 | 12

即以 UID 或NAME为条件，获取 JIFEN及MONEY表内对应UID 或NAME 的 SUM0 及SUM1 的统计结果

select j.UID,j.user,j.SUM0,m.SUM1
from
    (select UID,user,sum(SUM0) as SUM0
    from JIFEN
    group by UID,user) j
join
    (select UID,user,sum(SUM1) as SUM1
    from MONEY
    group by UID,user) m
on j.UID=m.UID

SELECT U.UID,U.NAME,(SELECT SUM(J.SUM0) FROM JIFEN AS J WHERE J.UID=U.UID) AS SUM0,(SELECT SUM(M.SUM1) FROM MONEY AS M WHERE M.UID=U.UID) AS SUM1  FROM USER AS U

select u.UID,u.NAME,SUM(j.SUM0) as sum0,SUM(m.SUM1) as sum1
from UID u 
left join JIFEN j on u.UID=j.UID
left join MONEY m on u.UID=m.UID
where u.UID=#{uid}