title: Laravel: OrderBy not working?
body: <p>I am trying to get all of the records in modal <code>Roleplay</code> order by the <code>payslips_collected ASC</code> (ascending). </p>
  
  <p>Ascending is meant to start at the lowest value and go up. I am not getting that... here is my result of a table I made.</p>
  
  <pre><code>+----+------------------+--------+-------------+-----------------+-----------------+--------------+-----------+
  | ID |    Username      | Shifts |  Completed  |  Registered     | Website Login   | Client Login | Last Seen |
  +----+------------------+--------+-------------+-----------------+-----------------+--------------+-----------+
  | 1  |  Danny Fure      |   29   | 1 year ago  |  43 minutes ago | 43 minutes ago  | 1 second ago |           |
  | 2  |  James Mack      |   0    | 1 year ago  |  1 second ago   | 2 days ago      | 1 second ago |           |
  | 3  |  Peter Barlow    |   0    | 1 year ago  |  1 second ago   | 2 days ago      | 1 second ago |           |
  | 4  |  Adam Chapman    |   0    | 1 year ago  |  1 second ago   | 2 days ago      | 1 second ago |           |
  | 5  |  Danny Burrows   |   0    | 1 year ago  |  1 second ago   | 2 days ago      | 1 second ago |           |
  | 6  |  Kieran Root     |   0    | 1 year ago  |  1 second ago   | 2 days ago      | 1 second ago |           |
  | 8  |  Ashton David    |   0    | 1 year ago  |  1 second ago   | 2 days ago      | 1 second ago |           |
  | 9  |  Someone Special |   0    | 1 year ago  |  1 second ago   | 2 days ago      | 1 second ago |           |
  | 10 |  Kelly Clark     |   0    | 1 year ago  |  1 second ago   | 2 days ago      | 1 second ago |           |
  | 11 |  Abbie Grove     |   0    | 1 year ago  |  1 second ago   | 2 days ago      | 1 second ago |           |
  +----+------------------+--------+-------------+-----------------+-----------------+--------------+-----------+
  </code></pre>
  
  <p>I'm sorry its a bit messed up, it didn't format correctly. But anyway, the main issue is its showing in <code>DESC</code> order, (descending) showing the highest before the lowest.</p>
  
  <p>Can anyone tell me why its doing this?</p>
  
  <p>Raw Query:</p>
  
  <pre><code>select * from `users` where exists (select * from `srp_user_statistics` where `users`.`id` = `srp_user_statistics`.`user_id` order by `payslips_collected` asc)
  </code></pre>
  
  <p>Code:</p>
  
  <pre><code>$players = Player::whereHas('roleplay', function ($query) use($orderType) {
      $query-&gt;orderBy('payslips_collected', $orderType);
  });
  </code></pre>