SELECT *
FROM parent p
JOIN child c ON p.parent_id = c.parent_id
WHERE c.child_id = (
    SELECT child_id
    FROM child
    WHERE parent_id = p.parent_id
    ORDER BY created_at DESC
    LIMIT 1
);