Improve performance for retriving all rolesNames for roleIds in Auth.js

[abubkr-hago]

Current Limitation

The current implementation for resolving user roles and their nested roles performs multiple iterations over two collections (the _Role and _User relations).
This approach can lead to inefficiencies, especially when dealing with deep or complex role hierarchies.

---

Feature / Enhancement Description

Optimize the role resolution logic by reducing the number of iterations and database queries.
Introduce a more efficient mechanism to recursively resolve nested roles, potentially using $graphLookup aggregation pipeline.

[parse-github-assistant]

🚀 Thanks for opening this issue!

[mtrezza]

Don't we have en open issue for this? Sounds quite familiar.

[abubkr-hago]

Yes, there is an issue (#8541) and a draft PR (#6556) I haven't noticed.