I am trying to display hierarchical data with MySQL (MariaDB) query, to show relationships,( like list of recipes, corporate org chart or program hierarchy). I can do some manipulation in PHP if required. In DB2 I can use CONNECT_BY_ROOT and CONNECT BY PRIOR to make these relationships, but MySQL does not support this vocabulary.

I am trying to display hierarchical data with MySQL (MariaDB) query, to show relationships,( like list of recipes, corporate Org Chart or program hierarchy). See example below. I can do some manipulation in PHP if required. In DB2 I can use CONNECT_BY_ROOT and CONNECT BY PRIOR to make these relationships, but MySQL does not support this vocabulary.