How is the server designed for the “state” and “talk” functions of simple social applications?

  mysql, question

I have only developed a simple RESTFUL interface and recently need to provide server-side support for a function similar to a circle of friends! Yii2.0 is adopted as the development framework.
In the circle of friends, a status mainly consists of status content, pictures, number of likes, number of comments, and even number of likes. How is the server designed? How should SQL statements be designed? Or is there a more efficient solution?

MySQL is not recommended, NOSQL is more suitable.