paulzi / yii2-adjacency-list

                ->select(["lvl0.[[{$primaryKey}]] AS lvl0"])

                ->from("{$tableName} lvl0")

                ->where(["lvl0.[[{$this->parentAttribute}]]" => $lastLevelIds]);

            if ($this->sortable !== false) {

                $query->orderBy(["lvl0.[[{$this->behavior->sortAttribute}]]" => SORT_ASC]);

            }

            for ($i = 0; $i < $this->childrenJoinLevels && ($depth === null || $i + $depthCur + 1 < $depth); $i++) {

                $depthCur++;

                $levels++;

                        "lvl{$j}.[[{$this->parentAttribute}]] = lvl{$i}.[[{$primaryKey}]]",

                        ['is not', "lvl{$i}.[[{$primaryKey}]]", null],

                    ]);

                if ($this->sortable !== false) {

                    $query->addOrderBy(["lvl{$j}.[[{$this->behavior->sortAttribute}]]" => SORT_ASC]);

                }

            }

            if ($this->childrenJoinLevels) {

                $columns = [];