public function findNodesTreeSorted() { $queryBuilder = $this->createQueryBuilder('o'); $queryBuilder->orderBy('o.root')->addOrderBy('o.left')->addOrderBy('o.position'); return $queryBuilder->getQuery()->getResult(); }