Mongodb使用语句笔记

1、使用aggregate完成简单的聚合查询

db.user_info.aggregate([
    
    {
        $lookup: 
        {
            from: "user_login_info",
            localField: "_id",
            foreignField: "user_id",
            as: "loginInfo"
        }
    },
    {
        "$unwind": "$loginInfo"
    },
    {
        "$project": {
            "user_id": "$_id",
            "user_no": 1,
            "token": 1,
            "nickname": 1,
            "avatar": 1,
            "is_online": "$loginInfo.is_online"
        }
    },
       {
           "$match": {
            "user_no": "169761"
                     
        }
           
    },
		{
        "$limit": 1
    },
])