tp5 关联查询问题

Question

表 User
id name
表 Order
id user_id
表 Goods
id order_id name

获取所有数据
1. $this->with(['User','Goods'])->limit($pages,$get['limit'])->select();

得到数据

[
  {
    "id": 1,
    "username": "用户A",
    "Goods": [
      {
        "id": 1,
        "name": "产品1"
      },
      {
        "id": 2,
        "name": "产品2"
      },
      {
        "id": 3,
        "name": "产品3"
      }
    ]
  },
  {
    "id": 2,
    "username": "用户A",
    "Goods": [
      {
        "id": 4,
        "name": "产品4"
      },
      {
        "id": 2,
        "name": "产品2"
      }
    ]
  },
  {
    "id": 3,
    "username": "用户B",
    "Goods": [
      {
        "id": 1,
        "name": "产品1"
      },
      {
        "id": 7,
        "name": "产品7"
      }
    ]
  }
]

现在想关联查询获得如下数据，不知道怎么操作

[
  {
    "id": 1,
    "username": "用户A",
    "Goods": [
      {
        "id": 2,
        "name": "产品2"
      }
    ]
  },
  {
    "id": 2,
    "username": "用户A",
    "Goods": [
      {
        "id": 2,
        "name": "产品2"
      }
    ]
  }
]

Answer 1

额.我是不是可以理解为,你就是想查产品2关联了哪些用户啊?

Answer 2

虽然我也没太理解你要获取啥，但是似乎查完后遍历一下就搞定了

Answer 3

为什么要用orm呢，反正觉得用join清晰简单点