求助，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'