语句被终止。完成执行语句前已用完最大递归 9

Question

with cte(u_name,u_referess) as (select u_name,u_referess from userMember where u_referess = 'ceshi' union all select t.u_name,t.u_referess from userMember as t inner join cte as c on t.u_referess = c.u_name ) select COUNT(distinct u_name) from cte option (maxrecursion 9)
我只想递归9次并获取对应的总人数数据，但是报错：语句被终止。完成执行语句前已用完最大递归 9。如何解决并获取对应的总人数数据。

Answer 1

https://www.cnblogs.com/xiaoerlang90/p/5842543.html