How create a views showing sponsored user profile field

I created a profile field called Sponsor name, who sponsor or introduce him into the website. The sponsor must be a user in the website. A user can spons开发者_开发知识库or any number of users to the website. When a user wants to register, he must give the sponsor name. I have done it successfully.

Now I want to create a view showing a list of sponsored users corresponding to each user.

for example: User James sponsor's

• Williams
• Perter
• John

User Williams sponsor's

• Adam
• Jimmy

Thanks in advance.

If you want a single page per user, then what you would want to do is to add an argument to your view. Where the argument would be the field you created for the sponsors name, and then in the settings for that argument, you would get the user id or username from the URL.