SELECT
   `i`.`id_item`,
   `c`.`id_category`
FROM `items` AS `i`
LEFT JOIN `categories` AS `c` ON c.id_category = i.id_category
WHERE (i.id_page = '7')
ORDER BY `c`.`id_category` ASC, `i`.`id_item` ASC