สอบถามโค้ด php mysql สรุปยอดขายรวมแบ่งตามทีมให้หน่อยครับ

CREATE TABLE sales
    (`id` int, `name` varchar(1), `level` int, `upper` varchar(4), `sales` int)
;
    
INSERT INTO sales
    (`id`, `name`, `level`, `upper`, `sales`)
VALUES
    (1, 'I', 0, NULL, 5000),
    (2, 'A', 1, 'I', 4000),
    (3, 'B', 1, 'I', 2000),
    (4, 'C', 1, 'I', 1000),
    (5, 'A', 2, 'A', 1000),
    (6, 'B', 2, 'A', 5000),
    (7, 'C', 2, 'A', 2000),
    (8, 'D', 2, 'C', 2000),
    (9, 'E', 2, 'C', 3000)
;

(SELECT name, sum(sales) team_sum FROM sales)
UNION
(SELECT name,
       ( Ifnull(l2.su, 0) + sales ) team_sum
FROM   sales
       LEFT JOIN (SELECT upper,
                         Sum(sales) su
                  FROM   sales
                  WHERE  level = 2
                  GROUP  BY upper) l2
              ON sales.name = l2.upper
WHERE  level = 1);

while ( $ro = $TableResult->fetch_array()){
  // ......
}

select user_id, sale
, (
    select sum(sale) from tablename 
    where parent_id like concat(u.parent_id, if(u.parent_id>'',',',''), u.user_id, '%') 
) as sum_child
from tablename u