Normalise Entities (Many to Many relations)

### Contact Details

alexandermatthew12@gmail.com

### What is the expected behavior?

Stateless query

We should normalise, such as `Profile` having followers & following which is an array of IDs

In addition, if a user follows my Profile
We should append a new `Profile` into the `followers` field, and append Profile to `following` field, for the follower Profile

### What is the current behavior?

We should not have boolean flags such as `hasCollectedByMe`, `isFollowingMe`, etc

We want to make the query stateless, meaning that there is no "me" object when querying here

### Reproduction steps

_No response_

### Version

_No response_

### Relevant log output

_No response_

### Your Environment

* Version used:
* Environment name and version (e.g. Chrome 39, node.js 5.4):
* Operating System and version (desktop or mobile):
* Link to your project:

### Code of Conduct

- [X] I agree to follow this project's Code of Conduct

Start by locating the Profile entity and the query definitions that expose followers, following, and the current boolean flags. Review how a user-follow relationship is represented, then clarify the relation model and stateless query behavior with maintainers. Done means the intended entity shape and relationship updates are implemented without user-specific flags, with relevant queries verified.

Written by the indexing model from the issue text.