id_, company_id_, catalog_id_ SELECT c.*,o.path_ as companyFullId FROM biz_company_catalog c LEFT JOIN uc_org o ON o.id_ = c.company_id_ WHERE o.is_dele_ ='0'