How to write a recursive procedure in MySQL?

Question

MySQL

Everything is said in my question.
And the goal...
A table of product categories in the form of a tree. Procedure I want to update Left Right limits. If there are other ways, I'm ready to listen.

Answer 1

https://stackoverflow.com/questions/3438111/mysql-...

Answer 2

cte with recursive
but you can do without it