Stored Procedure

Question

Hi i have two column named emp_id and reporting_to
if i login with a emp_id then
how it will return those employees who reporting to the person or who is working under those who is login then what will be the stored procedure for that.








Thanks in Advance