Untitled

SELECT *, c.name as colorName, s.name as sizeName FROM products_variants p 
        INNER JOIN colors c ON p.color_id = c.id 
        INNER JOIN sizes s ON p.size_id = s.id 
        WHERE product_id = :product_id