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