title: INNER JOIN same table
body: <p>I am trying to get some rows from the same table. It's a user table: user has <code>user_id</code> and <code>user_parent_id</code>. </p>
  
  <p>I need to get the <code>user_id</code> row and <code>user_parent_id</code> row. I have coded something like this:</p>
  
  <pre><code>SELECT user.user_fname, user.user_lname
  FROM users as user
  INNER JOIN users AS parent
  ON parent.user_parent_id = user.user_id
  WHERE user.user_id = $_GET[id]
  </code></pre>
  
  <p>But it doesn't show the results. I want to display user record and its parent record.</p>