如何对Firebase联接查询进行排序

<!-- Firebase App (the core Firebase SDK) -->
<script src="https://www.gstatic.com/firebasejs/9.6.1/firebase-app.js"></script>

<!-- Add Firebase products that you want to use -->
<script src="https://www.gstatic.com/firebasejs/9.6.1/firebase-firestore.js"></script>

const firebaseConfig = {
  apiKey: "YOUR_API_KEY",
  authDomain: "YOUR_AUTH_DOMAIN",
  projectId: "YOUR_PROJECT_ID",
  storageBucket: "YOUR_STORAGE_BUCKET",
  messagingSenderId: "YOUR_MESSAGING_SENDER_ID",
  appId: "YOUR_APP_ID"
};

firebase.initializeApp(firebaseConfig);

const db = firebase.firestore();

const usersRef = db.collection("users");
const postsRef = db.collection("posts");

// 创建一个联接查询，按用户年龄升序排序
const sortedPosts = postsRef
  .orderBy("age", "asc")
  // 使用join操作将帖子与用户关联起来
  .onSnapshot((snapshot) => {
    snapshot.docChanges().forEach((change) => {
      if (change.type === "added") {
        const post = change.doc.data();
        const userId = post.userId;
        const userRef = usersRef.doc(userId);

        userRef.get().then((userDoc) => {
          const userData = userDoc.data();
          console.log("User:", userData);
          console.log("Post:", post);
        });
      }
    });
  });