Many to many from a view

[vsDizzy]

Imagine we have users in companies and a view representing many to many in a single table.

The goal is to get two company entities from three raw rows by grouping them:

[
  {
    "id": 1,
    "name": "google",
    "users": [
      { "id": 1, "name": "Alice" },
      { "id": 2, "name": "Bob" }
    ]
  },
  {
    "id": 2,
    "name": "microsoft",
    "users": [{ "id": 3, "name": "Charlie" }]
  }
]

Is there anything ORM can help me with the grouping? 🤔

P.S. Here is SQL for this table:

DROP TABLE IF EXISTS "companies-view";

CREATE TABLE
  "companies-view" (
    "c_id" integer NOT NULL,
    "c_name" text,
    "u_id" integer NOT NULL,
    "u_name" text
  );

INSERT INTO
  "companies-view" ("c_id", "c_name", "u_id", "u_name")
VALUES
  (1, 'google', 1, 'Alice'),
  (1, 'google', 2, 'Bob'),
  (2, 'microsoft', 3, 'Charlie');