SELECT `tbl_treatment_catogeries`.`id`, `tbl_treatment_catogeries`.`catogerie_name`, `tbl_treatment_catogeries`.`catogerie_slug` FROM `tbl_treatment_catogeries` INNER JOIN `tbl_hospitals_details` ON `tbl_hospitals_details`.`treatment_type_ids` = `tbl_treatment_catogeries`.`id` WHERE `tbl_hospitals_details`.`isDeleted` = 0 GROUP BY `tbl_treatment_catogeries`.`id` ORDER BY `tbl_treatment_catogeries`.`catogerie_name` ASC