1 $profit=Db::view('profit','settlement_time,money,balance_account,balance_account1,did,user') 2 ->view('dealer','company_name','dealer.id=profit.did') 3 ->where($d) 4 ->order('settlement_time','desc') 5 ->paginate(10,false,['query'=>request()->param()]);