How to properly design a database with subscriptions?

Question

Database design

Tell me, I want to implement subscriptions on the site to accounts, how to design it correctly?
I see only one option: create a separate table:
id | *column who subscribed* | *column who subscribed to*
and make a many-to-one or one-to-many connection. Will this be the correct solution, or is there another way?

Answer 1

Yes, such a table is a standard solution, it doesn't even need an id.

and make a many-to-one or one-to-many connection

What does "do" mean? You have already made this table many-to-many

Answer 2

Only other people can follow a person. Actually, that's all. No need to complicate