Eloquent Order by Field

CatalogController.php

<?php
class CatalogController extends Controller
{
  public function catalogLists()
  {
  	$subcatids = implode(',', $this->subcategoryIds());
  	
    $subcategories = \App\Subcategory::whereIn('subcatid', $this->subcategoryIds())
                                        ->orderByRaw("FIELD(subcatid, $subcatids)")
                                        ->get();
    // show subcategories name order by field                                   
    dd($subcategories->lists('name'));
    
  }

  /**
   * Get Subcategory ids sort by submenus
   * @return array subcategory id
   */
  protected function subcategoryIds()
  {
    $subcatids = \App\Submenu::orderBy('id')->lists('subcategory_id');

    $subcatids = array_where($subcatids, function($key, $subcatid){
      return !is_null($subcatid);
    });

    return $subcatids;
  }
}