php - mysql 中的月份名称排序

Question

亲爱的 friend ，我需要帮助，

这是我的查询，

$customer = DB::table('customer');
$customer->join('customer_month_calender', 
   'customer_month_calender.customer_id', '=', 'customer.id','left');

$customer->select('customer.id','customer_month_calender.month');
//$customer->where(DATE_FORMAT(month,'%m')=date('m',strtotime('+1 month')));
$customer->orderBy('customer_month_calender.month', 'create_date');
$customer->groupBy('customer.id');

return $customer->get(); 

此查询返回值，

April  
August  
December  
February  
January  
July  
June

但是，我想按顺序排列月份名称

(即一月、二月、三月……直到最后一个是十二月)。

请帮忙。提前致谢。

Answer 1

您可以使用 orderBy 和 raw 查询编写这样的查询:

$customer = DB::table('customer');
$customer->join('customer_month_calender', 
   'customer_month_calender.customer_id', '=', 'customer.id','left');

$customer->select('customer.id','customer_month_calender.month');
//$customer->where(DATE_FORMAT(month,'%m')=date('m',strtotime('+1 month')));
$customer->orderBy(DB::raw('month(create_date) ASC'));
$customer->groupBy('customer.id');

return $customer->get();