alias('a') ->where('a.status','=',1) ->where('shop_supplier_id','=',$shop_supplier_id) ->join('supplier_service_security s','s.service_security_id=a.service_security_id') ->field('name,describe') ->order(['a.create_time' => 'asc']) ->select(); return $list; } }