What you need is good old array_agg(expression) with group by. Json capabilities may be needed for more complex hierarchical structures.