在单个查询MYSQL中从同一个表中选择两种类型的信息

I have a 'users' table like bellow. When a new user sign in, he has to use one 'sponsor_id' from previous user. Previous user's 'user_name' being used as 'sponsor_id' for a new user. Now, I want to show some 'sponsor_id' details when a new user signed in like, sponsor_id's first_name, last_name, phone etc. All data are saved in 'users' table. What should be the query,Please anyone help me. I am using Laravel5.4. I am trying something like- I have a 'users' table like bellow. When a new