Need code for get name using id

Question

Hi,

 

If i need how can i get  name using id in php.

need query with explaination.

I have two tables.

 

name :admin

 

2nd table :depatment

 

dept table have admin id .

 

i get dept table admin id using admin name