MySQL/GROUP_CONCAT

SELECT GROUP_CONCAT(DISTINCT(`term_data`.`name`) SEPARATOR ',')
FROM `content_field_organization_type` INNER JOIN `term_data` ON `content_field_organization_type`.`field_organization_type_value` = `term_data`.`tid`
WHERE `nid` =30731