i like the MPTT / nested set model to store trees in tables. https://en.m.wikipedia.org/wiki/Nested_set_model https://en.m.wikipedia.org/wiki/Nested_set_model

i like the MPTT / nested set model to store trees in tables. https://en.m.wikipedia.org/wiki/Nested_set_model https://en.m.wikipedia.org/wiki/Nested_set_model https://stackoverflow.com/questions/5368299/hierarchical-data-nested-set-model-mysql https://stackoverflow.com/questions/5368299/hierarchical-dat... this can be used to make these fake trees while avoiding the adjacency structure that's harder to query.