我如何重写以下SP以面对MySQL中的递归限制:CREATEDEFINER=`root`@`localhost`PROCEDURE`SP_DeleteParentDirectory`(pParentIDINT,pIsFolderINT,pReferenceIDINT)BEGINSET@@SESSION.max_sp_recursion_depth=255;SET@IsFolder=NULL;SET@ChildID=NULL;SET@ReferenceID=NULL;IF(pIsFolder=2)THENSELECTFileIDINTO@ChildIDFROMfilesinfoWHERE