云数据库JQL多表联查语句，怎么写

问题：
有两个表 A和B，A中有主键，是B表的外键，B表有时间戳类型的字段。
现有查询需求，A表和B表联查，根据B表的时间戳类型字段降序，这条语句应该怎么写？
鄙人根据文档尝试了多次，除非将时间戳类型的字段放在A表，否则无法排序，应该是鄙人的才疏学浅，希望看到问题的各位大神，帮帮忙，鄙人不胜感激。

下面是我写的语句

const ud = db.collection('atdb-main-things').where("user_id == '648ae1b9819ce82bda56d217'").getTemp()  
const any = db.collection('atdb-any-things').orderBy('thing_time desc').limit(1).getTemp();  
db.collection(ud,any).orderBy('any.thing_time asc').get()

上面的最后一句把asc改为desc也没有效果

下面是查询出来的结果：

{  
        "_id": "648c083409e298c790bf8148",  
        "create_time": 1686898740323,  
        "info": "去看看他家长说我是",  
        "thing_id": {  
            "_value": "W2sQfM1686898738386",  
            "atdb-any-things": [  
                {  
                    "_id": "648c0835f43e6001c1b565c1",  
                    "create_time": 1686898741412,  
                    "info": "去看看他家长说我是",  
                    "thing_id": "W2sQfM1686898738386",  
                    "thing_time": 1686898493000,  
                    "update_time": 1686898741412  
                }  
            ]  
        },  
        "thing_time": 1686898493000,  
        "title": "看出来了，你好，你",  
        "update_time": 1686898740323,  
        "user_id": "648ae1b9819ce82bda56d217"  
    },  
    {  
        "_id": "648fec0209e298c79072e5c4",  
        "create_time": 1687153665994,  
        "info": "弟弟明敏恩爱夫妻肺片",  
        "thing_id": {  
            "_value": "yBswbT1687153664811",  
            "atdb-any-things": [  
                {  
                    "_id": "648fec020c801c4baa528808",  
                    "create_time": 1687153666322,  
                    "info": "弟弟明敏恩爱夫妻肺片",  
                    "thing_id": "yBswbT1687153664811",  
                    "thing_time": 1687153650605,  
                    "update_time": 1687153666322  
                }  
            ]  
        },  
        "thing_time": 1687153650605,  
        "title": "我拉个",  
        "update_time": 1687153665994,  
        "user_id": "648ae1b9819ce82bda56d217"  
    },