MySQL nested set model, how to output parent from child perspective

The MySQL nested set model is used to print "parent from child" but it doesn't work

Below is the table containing the category.

Table containing the

Below is a query that prints the parent from the child's perspective.

select node.rgt, concat(repeat(', count(parent.category_name)-1), node.category_name) as name, node.category_description
from category as node, category as parent 
where node.lft between parent.lft and 4
group by node.category_name order by node.lft;  

Below is the result of the query.

Looking at the execution results, I would like to display the execution results in three columns per line.
How do you think it will work?I look forward to your kind cooperation.