SELECT `a`.`id`, concat(a.name, " / ", b.name) as department
FROM `company__department` `a`
JOIN `company__branch` `b` ON `b`.`id` = `a`.`branch_id`
WHERE `a`.`is_delete` = 0
ORDER BY `a`.`name`, `b`.`name`