How to hide a tree branch in Yii, with unlimited nesting of descendants?

Question

Yii

Good afternoon,
there is a table in a DB where records have an unlimited nesting.
How to get a list of elements, without descendants, descendants of descendants, descendants of descendants...etc.
Getting without descendants is pretty easy
$model->findAll('parent_id !='.$id);
. But how to exclude all descendants?
Needed for editing so that the element's parent cannot be one of its children.

Answer 1

Here is the solution
Model:

public function exceptChild($data,$rootID){
        foreach($data as $id => $node){
            if($node->parent_id == $rootID){
                unset($data[$id]);
                $data = $this->exceptChild($data,$node->id);
            }
        }
        return $data;
    }

Controller:
id - the id of the post whose branch to hide.

$data = $model->exceptChild($model->findAll('id !='.$id),$id);

Answer 2

Or maybe it is worth changing the structure of the database a little?
nested sets take a look