thinkphp关联模型 多对多 插入 怎么使用？？？？？

$u = D('user');
        $u->name = 'xiak';
        $u->password = 'qqqqqq';
        $u->shop = array(
                'gg' => '1',
            );
        $u->relation(true)->add($data);

user(id, name)
shop(id, name)
user_shop(user_id,shop_id)

class UserModel extends RelationModel {
    protected $_link = array(
        'shop' => array(
            'mapping_type' => self::MANY_TO_MANY,
            'relation_table' => '__USER_SHOP__',
                            )
                       }

怎么没有效果啊？

sql调试是这样的：

[user] SHOW COLUMNS FROM `tb_user` (executeTime: 0.009001s )
 [user] INSERT INTO `tb_user` (`name`,`password`) VALUES ('xiak','qqqqqq') (executeTime: 0.117007s )
 [shop] SHOW COLUMNS FROM `tb_shop` (executeTime: 0.013001s )
 [shop] INSERT INTO tb_user_shop (user_id,shop_id) SELECT a.id,b.id FROM tb_user AS a ,tb_shop AS b where a.id =45 AND b.id IN (1) (executeTime: 0.001000s )

手册上说 当MANY_TO_MANY时，不建议使用关联插入。是什么意思啊？

回复内容：

$u = D('user');
        $u->name = 'xiak';
        $u->password = 'qqqqqq';
        $u->shop = array(
                'gg' => '1',
            );
        $u->relation(true)->add($data);

user(id, name)
shop(id, name)
user_shop(user_id,shop_id)

class UserModel extends RelationModel {
    protected $_link = array(
        'shop' => array(
            'mapping_type' => self::MANY_TO_MANY,
            'relation_table' => '__USER_SHOP__',
                            )
                       }

怎么没有效果啊？

sql调试是这样的：

[user] SHOW COLUMNS FROM `tb_user` (executeTime: 0.009001s )
 [user] INSERT INTO `tb_user` (`name`,`password`) VALUES ('xiak','qqqqqq') (executeTime: 0.117007s )
 [shop] SHOW COLUMNS FROM `tb_shop` (executeTime: 0.013001s )
 [shop] INSERT INTO tb_user_shop (user_id,shop_id) SELECT a.id,b.id FROM tb_user AS a ,tb_shop AS b where a.id =45 AND b.id IN (1) (executeTime: 0.001000s )

手册上说 当MANY_TO_MANY时，不建议使用关联插入。是什么意思啊？

难道就没有人跟我一样，觉得分拆SQL再加事务才是最好的方案吗，关联的SQL其它人看起来是不是很受罪呢

php入门到就业线上直播课：查看学习

ThinkPHP6基础与实战：点击学习

课程从基础到实战详细分析讲解