lachang/database/seeds/UpdateCommissionBuyer.php

<?php

use app\common\model\OrderGoods;
use app\common\model\user\CommissionsDetail;
use think\migration\Seeder;

class UpdateCommissionBuyer extends Seeder
{
    /**
     * commissions_detail表加入消费者ID,更新此ID
     * Run Method.
     *
     * Write your database seeder using this method.
     *
     * More information on writing seeders is available here:
     * http://docs.phinx.org/en/latest/seeding.html
     */
    public function run()
    {
        $comms = CommissionsDetail::field('commission_id,order_goods_id')->where('buyer_user_id',0)->select()->toArray();
        foreach ($comms as $comm){
            $orderGoods = OrderGoods::where('order_goods_id',$comm['order_goods_id'])->find();
            if ($orderGoods){
                CommissionsDetail::where('commission_id',$comm['commission_id'])->update(['buyer_user_id'=>$orderGoods->user_id]);
            }
        }
    }
}