mysql 对比数据

    public function aqg()
    {
        set_time_limit(0);

        $db_rows =  Db::name('table1')->where('cl', 0)->limit(2000)->select();

        $phones_arr = [];
        $id_arr = [];

        foreach ($db_rows as $key => $row) {
           $phones_arr[]=$row['phone'];
           $id_arr[] = $row['id'];
        }

        if (!$id_arr) {
            exit('over');
        }

         

        $rows =  Db::name('table2')->where('dianhua', 'in', $phones_arr)->select();
            Db::name('table1')->where('id', 'in',  $id_arr)->update([
            'cl' => 1
           ]);
        foreach ($rows as $key => $row) {
           Db::name('table1')->where('phone', $row['dianhua'])->update([
            '11'=>$row['22'],
            'aa'=>$row['aa'],
            'bb'=>$row['bb'],
           ]);
        }

        var_dump(count($rows));


        $start = 1;


        echo '<script>setTimeout(function() { location=\'?start='.$start.'\';} , 1000)</script>';
    }