Nested self join in mongodb

[turivishal (Vishal Turi)]

Hi @Tamilselvan_95764 Welcome to MongoDB Community Forum,

See a topic this will help you,

Graphlookup to fetch a tree structure

I have a tree structure. node collection. { _id: ‘123’, } { _id: ‘444’, } { _id: ‘555’, } { _id: ‘666’, } hierarchy collection. { _id: ‘333’, parent: ‘123’, child: ‘444’, } { _id: ‘344’, parent: ‘123’, child: ‘555’, } { _id: ‘344’, parent: ‘555’, child: ‘666’, } Something similar to the above. Now i need to recursively fetch the entire tree. I want the result to be a single nested json. { _id: '123', subTasks: [ { _id: '444', }, { …