如何在aggregate中实现类似sql多层嵌套的查询? 比如sql张这个样子:

select * 
  from A
  left join (select * 
                from B 
                left join C
                on B.id=C.id) as D
  on A.id=D.id