方法一、直接用where和匿名函数用法: [php] view plain copy $list = DB::table($this->table) ->join('user', 'user.id', '=', $this->table . '.user_id') ->where(function($query) use($data) { if (!empty($data['order_sn'])) { $query->where($this->table . '.order_sn', 'like', '%' . $data['order_sn'] . '%'); } }) ->where(function($query) use($data) { if (isset($data['order_status']) && is_numeric($data[