How does php+mysql return data in pages according to the matching rate?

Question

For example, in this function, users can set their own tags, and then other users can choose the user tags they want to match, and return user information in pages from high to low according to the matching rate. How to design the table structure and how to query it? How to construct a query statement to return pages? Please help me to answer this question, thank you very much