如何创建一个MySQL层次递归查询

I have a MySQL table which is as follows:

我有一个MySQL表，如下所示:我有一