MySQL get values from the other table by using inner joins
Try this =>

SELECT DISTINCT (a.id_order_detail),(b.id_product),(b.name), img.id_image
        FROM ps_order_detail a join 
        ps_product_lang b on a.product_id=b.id_product 
        join ps_image img on img.id_product = b.id_product
where img.cover = 1
GROUP BY(name)