mysql递归删除子菜单_多级菜单项删除递归函数

我想从递归函数的多级菜单中删除类别。为了更仔细了解情况，让我们在MySQL表结构先来看看多级菜单项删除递归函数

CREATE TABLE IF NOT EXISTS menu(

id INT(5) NOT NULL AUTO_INCREMENT PRIMARY KEY,

p_id INT(5),

sort_id INT(5) NOT NULL,

title VARCHAR(50) CHARSET utf8 COLLATE 'utf8_unicode_ci' NOT NULL,

);

它看起来是这样的，当它被检索

id | p_id | sort_id | title |

1 | 0 | 1 | root1 |

2 | 1 | 1 | sub of root1

3 | 0 | 2 | root2 |

4 | 2 | 1 | sub of "sub of root1"

... | ... | ... | ....

etc ...

我写PHP脚本进行删除类别，这=>

function del_cat($connection,$id){

if (!$connection->connect_errno){

if ($connection->set_charset("utf8")){

if ($r = $connection->query("SELECT id FROM menu WHERE p_id=" . $id . "")){

if ($r->num_rows>0){

whi