title: Count rows in Laravel 4 database
body: <p>Hi I am trying to get the current count of my statement below , but I am getting only the count not the whole result:</p>
  
  <pre><code> $admins = DB::table('users')
      -&gt;select(DB::raw('count(users.id) as admin_count'))
       -&gt;where('users_roles.role_id', '=' ,0)
      -&gt;join('users_roles', 'users.id', '=', 'users_roles.user_id')
       -&gt;orderBy('first_name', 'asc')
      -&gt;get();
  </code></pre>
  
  <p>Could you tell me what I am doing wrong?</p>
  
  <p>Thanks</p>