sql query for reforing another column in same table : [this is my table][1]


This is my table 
Now i need to right query to return name as "student name" and teacher_id as teacher name by referring in the same table.
like below..
[I need result like this][2]


  [1]: https://i.stack.imgur.com/j6Z1N.png
  [2]: https://i.stack.imgur.com/eHZdn.png