How to select a parent in a tree stored in sql using the nested set method?

Question

MySQL

The question is right in the title - How to select a parent in a tree stored in sql using the nested set method?
There is a field in the table
name left_key right_key level
Need to choose a parent for category n, how to build a query?

Answer 1

Found a decent alternative