crm/database/migrations/20230427151606_add_old_vr_show_to_vrshow_table.php

<?php

use app\model\Grant;
use app\model\Permission;
use think\migration\Migrator;
use think\migration\db\Column;
use app\model\CustomerPortraitField;
use app\model\Company;
use app\model\CompanyVrshow;

class AddOldVrShowToVrshowTable extends Migrator
{
    public function change()
    {
        $addmod = new CompanyVrshow;
        $list= Company::where([['vr_show','<>','']])->field('id,root_id,vr_show')->select()->toArray();
        foreach($list as $key=>$val){
           $all[] = ['name'=>'','root_id'=>$val['root_id'],'url'=>$val['vr_show'],'type'=>1];
        }
        $addmod->saveAll($all);
    }

}