该声明终止。在语句完成之前，已耗尽最大递归100

I am writing a stored procedure for retrieving the xml structure for a menu control. This seems to be a valid code( according to me & it is wrong) but does not run well on query tester. How could i correct it of the error below is the codeI am writing a stored procedure for retrieving