title: Get same column twice, different value
body: <p>I have the following code (you don't need to know much of the query to get my question):</p>
  
  <pre><code>if ($stmt = $cxn-&gt;prepare('SELECT p.post_id, p.reply_to, p.parent_id, p.post_path, p.user_id, p.content, p.datetime, p.total_likes, p.total_replies, p.total_reposts, l.like_id, l.user_id, u.username, u.display_name 
          FROM posts p 
          LEFT JOIN users u ON p.user_id = u.user_id 
          LEFT JOIN likes l ON l.post_id = p.post_id 
          WHERE l.user_id IN 
              (SELECT user_id FROM likes WHERE user_id IN 
                  (SELECT following_id FROM follows WHERE user_id = ? AND following_id != ?)) 
          AND l.user_id != p.user_id AND p.removed != 1 
          ORDER BY p.datetime DESC LIMIT 26')) {
      $stmt-&gt;bind_param('ii', $id, $id);
      $stmt-&gt;execute();
      $stmt-&gt;store_result();
      $stmt-&gt;bind_result($post_id, $reply_to, $parent_id, $post_path, $user_id, $content, $datetime, $total_likes, $total_replies, $total_reposts, $like_id, $like_user_id, $username, $display_name);
  }
  </code></pre>
  
  <p>Right now, I have the <code>l.user_id</code> value which is the integer value of the user.</p>
  
  <p>How would I add to this query so that I can get the username of <code>l.user_id</code> from the <code>users</code> table when I'm already querying <code>u.username</code> for <code>p.user_id</code>?</p>
  
  <p>Thanks!</p>