You can do that in Postgres, either return nested json structures, or nested arrays.

For an example see: https://shusson.info/post/building-nested-json-objects-with-...