mssql 재귀함수 (트리구조)

WITH test( Uid, UserID, Name, upMember , MemberNo , level )
AS
(
SELECT Uid, UserID, Name, upMember , MemberNo , 1 AS level
FROM SP_MEMBER
WHERE upMember = '31139'
UNION ALL
SELECT a.Uid, a.UserID, a.Name, a.upMember , a.MemberNo , level+1 AS level
FROM SP_MEMBER a , test b
WHERE a.upMember = b.MemberNo
)
SELECT * FROM test