Nested sets how to remove a node and all children?

Question

PHP

I found a similar request, but it only removes the node itself, and all child elements remain in their places.
How can a node and all children be removed?

DELETE FROM my_tree WHERE left_key >= $left_key AND right_ key <= $right_key;
UPDATE my_tree SET left_key = IF(left_key > $left_key, left_key – ($right_key - $left_key + 1), left_key), right_key = right_key – ($right_key - $left_key + 1) WHERE right_key > $right_key

Answer 1

The request seems to be correct. Most likely the problem is in the wrong organization of the nested set in the database. In a correct nested set condition
describes a node with all its children.