How to fetch data from a relational database?

Question

MySQL

I ran into such a problem, the category field is connected to another categories table where these categories are stored, I usually access them from the back via Select * from where category = id, but when the category field is displayed, I get the category ID and I would like the name of the category. How to implement it?