How to get the email address from a table of user

Question

How to get a cascade value like the below scenirio 


I have one table in which there are different users i have just the userid .I want to pass that user id to stored procedure and then get the COuntry Name of that user and then find the other person having the same country as the selected user have.????