جلوگیری از حلقه بی نهایت در کوئری بازگشتی SQL Server

      with  p as (
	select id, parent_id, JSON_MODIFY('[]', 'append $', cast(id as nvarchar)) as path from t_content where id = 168401 -- initial
	union all
	select ps.id, ps.parent_id, JSON_MODIFY(p.path, 'append $', CAST(ps.id as nvarchar)) as path from t_content ps
	inner join p on p.parent_id= ps.id
	where ps.id not in (select j.value from openjson(p.path, '$') j)
)
SELECT *
FROM p
where parent is null;