title: How to order and sort my records from eloquent
body: <p>Hi I have a query which fetches all the category names and displays them in the frontend. now the problem is that category names have a field name called others ( it could be like other fruits or other vegetables etc). Now The others record names I want them to come in the last of the collection I get. </p>
  
  <p>The query </p>
  
  <pre><code>$subcat = Category::where('parent_category_id', 62)-&gt;where('is_active', 1)-&gt;lists('name', 'id');
  </code></pre>
  
  <p>What It is gonna return is </p>
  
  <pre><code>Illuminate\Support\Collection Object
      (
          [items:protected] =&gt; Array
          (
              [64] =&gt; Grapes
              [65] =&gt; Pineapple
              [66] =&gt; Cranberry
              [67] =&gt; Strawberry
              [68] =&gt; Pomogranate 
              [69] =&gt; Others //like this
              [71] =&gt; Orange &amp; Apple
              [72] =&gt; Guava &amp; Mango
              [73] =&gt; Mixed Fruit
              [384] =&gt; Other Juices //another one
              [395] =&gt; Concentrates
          )
  
      )
  </code></pre>
  
  <p>I want to place the other field names at the last. </p>
  
  <p>Please assist me. </p>