title: How to write a Mysql Query to select data from specific column?
body: <p>Here i like to explain my problem clearly</p>
  
  <p>This is my table</p>
  
  <pre><code>id  company_ID  Employee_ID Name        Relationship    Dob     Age Gender       
  1   EMPL        00001       Choodamani  Spouse      11-Aug-66   49  Female            
  2   EMPL        00001       Komala      Mother      30-Oct-39   76  Female            
  3   EMPL        00001       Varshini    Daughter    29-Apr-04   11  Female            
  4   EMPL        00001       Vasudevan   Employee    15-Jul-62   53  Male    
  5   EMPL        00002       Siddharth   Son         1-Jun-00    15  Male              
  6   EMPL        00002       Poongavanam Mother      21-Oct-39   76  Female            
  7   EMPL        00002       Aruna       Spouse      16-Sep-68   47  Female            
  8   EMPL        00002       Abirami     Daughter    7-May-97    18  Female            
  9   EMPL        00002       Murali      Employee    7-Oct-67    48  Male
  </code></pre>
  
  <p>please read the below scenario. thats my exact problem</p>
  
  <p>Here if i select a id <code>5</code>, using id <code>5</code> i need to get <code>employee_id</code>, using that employee_id i need to get name of employees who all belongs to that employee_id</p>
  
  <p>How can i write mysql query for this scenario</p>