Honest, it doesn't have to be complex.
And if you use "implicit joins" it can actually be pretty simple.
SELECT P.*, I.imgName
FROM products AS P, product_images AS I
WHERE P.productID = I.productID
AND P.product_name = 'left-handed widget'
Now, if you have multiple images, that is going to return all the data from the products table multiple times: Once per image.
But that's easy enough to sort out in your PHP code. If you are only getting a single product, just get the product info from the first record and then do a while loop to get all the imaName values, for example.