How to get multiple values ​​using JOIN?

Question

SQL

Greetings. I am writing a query with handles to extract WooCommerce products and link them to categories, but I ran into a problem.
I have the following query against the WordPress database:

SELECT 
       wp.`ID`, 
       wp.`post_title` as title, 
       wp.`post_name` as slug, 
       wtr.`term_taxonomy_id` as category, 
       wt.`name` as category_name  
FROM `wp_posts` as wp 
  INNER JOIN `wp_term_relationships` as wtr 
    ON wp.ID = wtr.object_id 
  INNER JOIN `wp_terms` as wt 
    ON wt.`term_id` = wtr.`term_taxonomy_id`
WHERE 
      `post_type` = 'product' AND 
      `post_status` = 'publish'

Everything works great, but the catch is that some products contain multiple categories in the wp_term_relationships table:

Is there any way to get multiple table items?
Alternative solutions, advice on the case are very welcome. Thanks in advance.

Answer 1

Well, your query returns several categories

spoiler

Answer 2

LEFT JOIN `wp_terms` as wt 
    ON wt.`term_id` = wtr.`term_taxonomy_id`