Laravel子查询

Question

我想在查询中使用子查询作为select。但是这个代码不能工作。

$listed_waiting_approach = DB::table('be_medical_insurance_for_foreigners')
    ->join('be_product','be_product.id','=','be_medical_insurance_for_foreigners.product_id')
    ->join('be_status','be_status.id','=','be_medical_insurance_for_foreigners.payment_status_id')
    ->where('be_medical_insurance_for_foreigners.is_approved','=',false)
    ->where('be_medical_insurance_for_foreigners.is_active','=',true)
    ->where('be_medical_insurance_for_foreigners.payment_status_id','=',$payment_status_id1)
    ->where('be_medical_insurance_for_foreigners.order_status_id','=',$order_status_id1)
    ->select('be_medical_insurance_for_foreigners.*','be_product.name as productname','be_medical_insurance_for_foreigners.is_approved as approve','be_status.code as statuscode','**(SELECT code FROM be_status WHERE id=$payment_status_id1 ) as paymentname**')
    ->get();

Answer 1

您可以将DB::raw与DB::select组合使用。这有点像

DB::select( DB::raw( " ... ") )

Answer 2

您也可以使用selectRaw

DB::table('be_medical_insurance_for_foreigners')
    ->selectRaw("be_medical_insurance_for_foreigners.*, be_product.name as productname, be_medical_insurance_for_foreigners.is_approved as approve, be_status.code as statuscode, (SELECT code FROM be_status WHERE id={$payment_status_id1}) as paymentname")
    ->get();