Message system Query

Capture1045×281 24.1 KB

I have been trying to create a message query with two tables using wappler server action
1 - User
2 - Message

when I join user ID from table 1 to table 2.
I was only able to join sender ID or Receiver ID to display their real name.
sender ID and Receiver ID are both in table user but only one will show the name.
I tried to add a variable array and repeat region in the server action - I am still with nothing.

Is there any steps someone can help with this section?3

Thank you