MySQL使用递归存储过程实现树状结构，实现Oracle的Connect By 功能在Mysql中如何实现Oracle中的递归

<select id="getTreeMenu" parameterClass ="map" resultClass="menu">
  select * from (select * from tbl_menu where 1=1
  
  <isEqual prepend="AND" property="menuScope" compareValue ="INFO">
   coltype in ('NEWS','IMAGE','DOWN')
  </isEqual>
  <isEqual prepend="AND" property="state" compareValue ="Y">
   state  = #state#
  </isEqual>
  <isEqual prepend="AND" property="state" compareValue ="N">
   state  = #state#
  </isEqual>
  <isNotEmpty prepend="AND" property="siteroot">
   siteroot = #siteroot#
  </isNotEmpty>
  )  start with 
  <isNotEmpty prepend="" property="pid">
   pid  = #pid#
  </isNotEmpty>
   connect by prior menuid = pid
   order by pid,xuhao
 </select>

 

MySQL使用递归存储过程实现树状结构，实现Oracle的Connect By 功能大家帮帮忙！我在网上搜到的我也做了，都不对！