title: Laravel join queries AS
body: <p>Any way of defining an <code>AS</code> for a query??</p>
  
  <p>I have tried the following:</p>
  
  <pre><code>$data = News::order_by('news.id', 'desc')
      -&gt;join('categories', 'news.category_id', '=', 'categories.id')
      -&gt;left_join('users', 'news.user_id', '=', 'users.id') // ['created_by']
      -&gt;left_join('users', 'news.modified_by', '=', 'users.id') // ['modified_by']
      -&gt;paginate(30, array('news.title', 'categories.name as categories', 'users.name as username'));
  </code></pre>
  
  <p>The problem is that <code>['name']</code> from categories will be replaces with the one from <code>users</code>. Any way of having them with different names?</p>
  
  <p>Having the aliases above... how can I create an alias where both joins return <code>users.name</code> ? </p>