How to store a list of categories in mysql?

Question

MySQL

There is news, she has a list of static categories to which she belongs. How to store this list of categories in the database? Table in the form: categoryName1:true, categoryName2:falseand so on? Or is there another option?

Answer 1

category tree table: ID;categoryName;parentCategoryID
news table: ID;text;timestamp;author
link table: ID;categoryID;articleID

Answer 2

Since @xmoonlight answered above
I can add that this type of relationship is called many-to-many

Answer 3

Since you say you have static categories, it's fine to use Nested Sets to store the categories. With a small number of category updates, they are much faster ...
Here is an example: zabolotnev.com/mysql-nested-sets