------------------------------------------------------------------------------------------------------------------------------------100011 | FA | 50 |100011 | FA | 100
SELECT json_agg((SELECT x FROM (SELECT json_agg((SELECT y FROM (SELECT s.id, s.name) y)) AS js2
) x)) AS js1INNER JOIN cc ON c.id = cc.c_id AND p.c_id = cc.c_