whereHas 一个多对多关联,会有数据丢失
- 问题描述
- 代码中whereHas一个belongsToMany的多对多关联,关联表中有多条符合关联的数据,始终只能找到第一条数据(尝试过交换关联数据的id),其余会丢失,为何?
模型关联关系如下图
代码关联
生成sql如下图
SELECT count( * ) AS AGGREGATE FROM `hospitals` WHERE `title` IN ( 'xxxxxx' ) AND EXISTS ( SELECT * FROM `territory` INNER JOIN `territory_hospital_relations` ON `territory`.`id` = `territory_hospital_relations`.`territory_id` WHERE `hospitals`.`id` = `territory_hospital_relations`.`hospital_id` AND `territory`.`id` in (95) AND `territory`.`deleted_at` IS NULL ) AND `hospitals`.`deleted_at` IS NULL
推荐文章: