laravel 中with关联查询限定查询字段

1.关联加入select指定字段

public function CustomerInfo()
    {
        return $this->belongsTo(CustomerInfo::class, 'customer_id', 'id')->select(['id', 'company_name', 'company_code', 'external_code', 'credit_total', 'customer_level', 'customer_state', 'goods_state']);
    }

 

2. 闭包内select指定字段

ActiveJieSuan::with(['user' => function ($query) {$query->select('id','name');},
   'active'=> function ($query) {
                $query->select('id','name','start');
    }
])
->paginate()->toArray();

 3.简便写法

ActiveJieSuan::with(['user:id,name','active:id,name,start'])
->paginate()
->toArray();