SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `psrbs_module` m LEFT JOIN `psrbs_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1