SELECT pl.*,
GROUP_CONCAT(DISTINCT pt.type_name ORDER BY pt.type_name SEPARATOR ', ') AS type_name
FROM p_product_library pl
LEFT JOIN p_library_type t ON pl.id = t.library_id
LEFT JOIN p_product_library_type pt ON t.type_id = pt.id
WHERE pl.deleted = 0
GROUP BY pl.id
DISTINCT