Permission settings for a friend circle, what do I do if I want to build a table?

We're doing this app now. One of the modules is similar to a circle of friends. One of these is the question about permissions:
1. Non-friends cannot comment.
2. I can only see my comments and the other person reply to me.
How can I clarify these relations, there is no general idea? Question I will be a little more detailed later, including my own implementation of the Code,,

This issue has been turned off because of an issue where the exact result cannot be obtained

Reply content:

We're doing this app now. One of the modules is similar to a circle of friends. One of these is the question about permissions:
1. Non-friends cannot comment.
2. I can only see my comments and the other person reply to me.
How can I clarify these relations, there is no general idea? Question I will be a little more detailed later, including my own implementation of the Code,,

According to your description: There is a friend table (id,uid-own id,fid-friend's id,time-to become friends of the time). Permission, according to the table inside the query, only look at their own list of the FID message.

