SELECT `a`.*, `b`.`name` as `company_name`
FROM `company__business_entity` `a`
LEFT JOIN `company` `b` ON `b`.`id` = `a`.`company_id`
WHERE `a`.`id` = '1'
AND `a`.`status` =0
AND `a`.`is_delete` =0
ORDER BY `a`.`name` ASC