How to do left join for User table?

I’m trying to get author informations with posts. I’m including category and can get category informations. But for user, its not successful. I’m adding the code and result. Is there any restriction for User collection?

const query = new Moralis.Query(“Posts”);
query.include(“category”);
query.include(“userId”);
const result = await query.first({useMasterKey:true});

{
“results”: [
{
“objectId”: “va9yJb7lF99RNEIvg8ZnRUQ7”,
“type”: 1,
“title”: "Test 7 ",
“description”: “Test 7 Description”,
“category”: {
“objectId”: “GL9SuRArYEpS6b5i5pOav7vM”,
“name”: “General”,
“order”: 1,
“createdAt”: “2022-02-21T09:58:04.432Z”,
“updatedAt”: “2022-02-21T09:58:08.769Z”,
“image”: {
“__type”: “File”,
“name”: “4ae66cb6cfcabaa5f1a5c4a3525ae707_77.png”,
“url”: “https://p00sw3vddstc.usemoralis.com:2053/server/files/IFdxfSMOZKAaSSbMqf0PskYEdUWD3hfOT3vEE0Ir/4ae66cb6cfcabaa5f1a5c4a3525ae707_77.png
},
“__type”: “Object”,
“className”: “ProductCategories”
},
“status”: “0”,
“likes”: 0,
“views”: 0,
“createdAt”: “2022-02-22T07:07:20.776Z”,
“updatedAt”: “2022-02-22T09:03:09.337Z”
}
]
}

Hello,

I have same problem. Can you help us?

Thanks.

You could try to also add .select similar to .include