iconv转码，yii2 关联表查询

$row = iconv('GB2312//IGNORE','UTF-8',fgets($file));

 $query = SalePolicy::find()->alias('sp')
            ->select('sp.channel,sp.id,sp.policy_no,sp.pre_policy_no,pi.pro_name,pic.company_name,sp.applicant_name,spp.scale_premium,spp.standard_premium,
            spp.value_premium,spp.payment_period,spp.have_flow_period,sp.payment,
            sp.advance_time,sp.underwrite_date,sp.effective_date,
            sp.policy_validity_date,sp.handle_code,sp.handle_name,sp.handle_uid')
            ->leftJoin(SalePolicyPro::tableName().'as spp','spp.policy_id=sp.id')
            ->leftJoin(ProInfo::tableName().'as pi','pi.id=spp.pro_id')
            ->leftJoin(ProInsuranceCompany::tableName().'as pic','pic.id=pi.company_id')
            ->where(['and','basic_law=2','channel=\'B1\'']);
           ->count();

         $sql = "update sale_policy sp left join sale_policy_pro spp on  spp.policy_id=sp.id  left join pro_info pi on pi.id=spp.pro_id
left join pro_insurance_company pic  on pic.id=pi.company_id  set sp.handle_name='".$data[16]."'
where sp.basic_law=2 and  sp.channel='B1' and pi.main_mark=1 and sp.id=".$data['id'];

         $query = $connect->createCommand($sql)->execute();