Hi - Thanks for sharing the link. To be frank i have already reviewed the links before posting the note but that doesn't give the exact query to get the user list. As mentioned in links - our environment is not suitable to get information through user admin console. Please suggest a exact query that pulls the member list in AEM? I believe that is really possible through query debugger
It is not adviced to make a query to fetch user list, as a group might contain uuid of another group as rep:member which in turns contains another group. It is not possible to fetch it using single query in query builder.
I would rather advice if possible please use group interface api and call below method to get list of members.