在X递归循环后停止查询

I have a recursive query. The query works in most of the cases only when there is an infinite loop I want to get some results back from the database instead of the I have a recursive query. The query works in mo