title: Join two different MySQL tables
body: <p>I have two tables in my database and I would like to join them. </p>
  
  <p>The purpose is to display all comments (friends and my own) on each article. I have managed to select and display my friends comments but not to join and display my own as well.</p>
  
  <p>Table structures</p>
  
  <p>friends:</p>
  
  <pre><code>id
  follower
  following
  </code></pre>
  
  <p>users</p>
  
  <pre><code>id
  name
  email
  </code></pre>
  
  <p>Query for friends so far:</p>
  
  <pre><code>SELECT following FROM friends WHERE follower='$follower'
  </code></pre>
  
  <p>Query for user:</p>
  
  <pre><code>SELECT id FROM users WHERE id='$follower' 
  </code></pre>