求助，oracle的connect by功能转换到mysql如何

在Oracle中sql代码如下编写select o.orgid from t_organization o   connect by prior o.orgid = o.orgparentid     start with o.orgid = #{params.swjgDm}那么在MySQL数据库中需要改为如下方式select o.orgid from t_organization o where  (o.ORGPARENTIDS LIKE concat('%/',#{params.swjgDm},'/%')  or o.ORGID =#{params.swjgDm}) and o.AVAILABLE ='1'