Select arbitrary amount of rows from child table and join them into parent table as columns
Try this:

SELECT 
    parent.id, 
    parent.name, 
    GROUP_CONCAT(CONCAT(child.attribute, ":", child.val)) AS Attributes
FROM parent INNER JOIN child ON parent.id=child.parent_id
GROUP BY parent.id