使用mysql / php中的id / parent_id模型获取记录的所有父项的最简单方法是什么？

I'm looking for the simplest way to recursively get all the parent elements from a database using the adjacency list / single table inheritance model (I'm looking for the simplest way to recursively