sql Server 的语句

WITH    taball
          AS ( SELECT   ID ,
                        PID ,
                        DirName,
                        Levels ,
                        DirDesc
               FROM     dbo.S_AttachDir
               WHERE    ID = '{ID}'
               UNION ALL
               SELECT   a.ID ,
                        a.PID ,
                        a.DirName ,
                        a.Levels ,
                        a.DirDesc
               FROM     taball
                        INNER JOIN dbo.S_AttachDir a ON taball.PID = a.ID
             )
    SELECT  *
    FROM    taball；
求大神解答，怎么用mysql语句实现