如何在Firebase中构造数据

我来自MySQL工作流，现在我正试图在Firebase中做一些事情，我在构建数据时遇到了一些难题，因为我不知道如何查询它。

在下面的例子中，我有一些users和一些comments，找到的好方法是什么

how many post likes a user had
how many post comments a user had
what were the posts that a user liked
...

我正在考虑将这些信息添加到用户中，比如：

  "user:2": {
    "name": "Doe",
    "email": "doe@bob.com",
    "post_likes": {
      "post:1": 1,
      "post:2": 1
    },
    "post_comments": {
      "post:1": 15,
      "post:2": 5
    }
  }

但这似乎是多余的，而且重复了数据。。

我需要找到一种方法在posts中搜索与user:1有关的所有内容，也许我需要创建另一个连接users和posts的对象？？

有什么想法吗？

{
  "array": {
    "users": {
      "user:1": {
        "name": "John",
        "email": "john@bob.com"
      },
      "user:2": {
        "name": "Doe",
        "email": "doe@bob.com"
      }
    },
    "posts": {
      "post:1": {
        "name": "First Post",
        "content": "some post content",
        "comments": {}
      },
      "post:2": {
        "name": "Second Post",
        "content": "some other post content",
        "likes": 2,
        "comments": {
          "comment:1": {
            "uid": "user:1",
            "email": "some comment"
          },
          "comment:2": {
            "uid": "user:2",
            "email": "some other comment"
          }
        }
      }
    }
  }
}