Is there a more detailed explanation of related query? What I want to implement is as follows

Question

service_category classification table, service_infor information table. These two tables, the information list needs to be related to the category name of the classification table through the classification field sid (category table id).

Answer 1

How is this achieved?