Resolve N+1 query issues and infinite loops when fetching hierarchical data via self-referencing API criteria.