根据指定的时间排序,然后再根据状态排序
$query = model::with([
]);
$query->field(['*',"CASE
WHEN remind_at <= '{$formatted_remind}' THEN 0
WHEN exp_at <= '{$formatted_timeout}' THEN 1
ELSE 2 END" => 'timeas']);
->order(['timeas' => 'asc'])
// 状态排序
->orderRaw("field(status,'ENABLED','DISABLED','PUBLISH','UNPUBLISH','DRAFT')");