如何在MySQL中执行递归选择查询?

I got a following table:

我有以下表格:

col1 | col2 | col3
-----+------+-------
1    | a    | 5
5    | d    | 3
3    | k    | 7
6    | o    | 2
2    | 0    | 8
col1 | col