How can we get a list of new users added to a role each week

Summary:

We need to get a list of new users added to a specific role weekly. Is there a query to determine the weekly list of new users who are assigned this specific role?

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):