closure table tree query

gettree

public function getTree($root, $level = 3)
    {
        $nodes =   DB::select(
            '
                    SELECT
                        members.id,
                        members.first_name,
                        members.leg_side,
                        members.parent_id
                      
                    FROM members
                        JOIN binary_plan_tree_paths ON members.id=binary_plan_tree_paths.descendant
                    WHERE binary_plan_tree_paths.ancestor=?
                    AND binary_plan_tree_paths.depth < ?',
            [$root,$level]
        );

        return $nodes;
    }