Mysql join SUM 求和问题

Mysql 主从表关联查询，汇总主表和从表的金额

table a(id, p_id,amount)， table b (id, a_id, amount)
按照p_id汇总 a 和 b 的金额

问题：
join 会出现主表数据重复，导致汇总主表数据不准确，

方法：
SELECT SUM(amount1),SUM(amount2) FROM (
SELECT o.p_id, o.amount amount1, SUM(t.amount) amount2 FROM a t
INNER JOIN b o ON o.id = t.a_id
GROUP BY o.p_id,o.id
) aa
GROUP BY aa.p_id;

先按照主表和查询id 分组 汇总明细，然后再根据查询字段分组汇总主表和明细。

SELECT SUM(amount) FROM t_invoice_receipt WHERE PROJECT_ID = 259;

SELECT SUM(amount) FROM t_invoice_receipt_detail WHERE INVOICE_ID in (SELECT id FROM t_invoice_receipt WHERE PROJECT_ID = 259)；

SELECT SUM(amount1),SUM(amount2) FROM (
SELECT o.PROJECT_ID, o.amount amount1, SUM(t.amount) amount2 FROM t_invoice_receipt_detail t
INNER JOIN t_invoice_receipt o ON o.id = t.INVOICE_ID
WHERE o.PROJECT_ID = 259
GROUP BY o.PROJECT_ID,o.id
) aa
GROUP BY aa.PROJECT_ID;