fetchAll(PDO::FETCH_GROUP|PDO::FETCH_ASSOC)
SELECT
m.name,
items.*
FROM menus m
LEFT JOIN menu_items items ON items.menu_id = m.id
WHERE m.id = 1;
SELECT m.id,
m.name,
items.*
FROM menus m
LEFT JOIN menu_items items ON items.menu_id = m.id
WHERE m.id = 1;
"UPDATE `books` SET `name`='$name', `author`='$author', `year`=$year, `pages`='$pages', `lang`='$lang', `description`='$desc', `categoryid`=$categoryid WHERE `id`=$bookid"