Nested set model build tree from node to JSON object

Question

I am working to build a category hierarchical like this:

Home

- Car
  - Yellow
  - Red
- Animal
  - Cat
     - Node1
     - Node2
  - Dog

I use php & mysql schema with nested set model:

- left
- right
- id

I want to get a tree from a Animal node to result and JSON structure this:

- Animal
  - Cat
     - Node1
     - Node2
  - Dog

I dont have any solution for that. Please help me !

If you're using nested set, then you need to do select with condition ` where left >= Animal's left and right <= Animal's right`. — Jakub Matczak
– Jakub Matczak, Commented Sep 7, 2017 at 9:33

megadruck · Accepted Answer · 2018-07-04 18:37:00Z

1

This post is old , but maybe it helps other. Good article written in german including sql queries. http://www.klempert.de/nested_sets/

answered Jul 4, 2018 at 18:37

megadruck

4371 gold badge6 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1