Nested data structure

I have a collection of the following items:

type Folder = {
  id: string;
  parentId?: string;
  name: string;
};

type Folder = {
  id: string;
  parentId?: string;
  name: string;
};

parentId

parentId

refers to another Folder. Is it possible to build a query that returns the collection as a nested data structure?