Doctrine 2 nested set - retrieve full tree in single query

Question

I'm using stof/StofDoctrineExtensionsBundle (Bundle wrapper for Atlantic18/DoctrineExtensions) to implement a Nested Set (tree) entity. The entity is configured and working, but I can't figure out how to retrieve all root notes with all of their children (full trees) in a single query. I currently have the full collection returning however it lazy loads all children, meaning a large number of queries is performed.

Thanks for any help.

Answer 1

You can just use childrenHierarchy() method for whole tree retrieve:

$tree = $repo->childrenHierarchy();