用Mysql怎样实现Oracle中的SYS_CONNECT_BY_PATH函数和START WITH ...CONNECT BY PRIOR方法

<!--  取所用带信息的终极栏目 高级搜索的栏目多选框使用  -->
  <select id="getMenuCatVOList" resultClass="MenucatVO"  parameterClass="MenucatVO" cacheModel="FSmenu-cache">
     <![CDATA[
    SELECT menuid,
                                       menuname,
                                       coltype,
                                       siteroot,
                                       ltrim(MAX(SYS_CONNECT_BY_PATH(menuname,'->')), '->') menunames
                                  FROM tbl_menu
                                 WHERE isendmenu = 'Y'
                                   AND siteroot = #siteroot#
                                   AND coltype=#coltype#
                                 START WITHpid = 0
                                CONNECT BY  PRIOR pid =menuid
                                 GROUP BY menuid,
                                          coltype,
                                          menuname, siteroot
                                 order by menuid desc
   
     ]]>
    </select>

请问用Mysql怎样实现以上方法？？显示我截图的效果，请多多指教