把一列的数据进行拼接

SELECT
      t1.KNSITSYO_ID
      , t2.knsitsyo_set_id
      , array_to_string( 
        array ( 
          SELECT distinct
            t3.hokanbasyo_name 
          from
            T_KNSITSYO_JOHOSSN t3 
          where
            t1.knsitsyo_id = t3.knsitsyo_id 
            and t2.knsitsyo_set_id = t3.knsitsyo_set_id 
            and (t3.del_flg is null or t3.del_flg = '0') 
          order by
            t3.hokanbasyo_name
        ) 
        , ','
      ) hokanbasyo_name 
    FROM
      t_knsitsyo t1 
      LEFT JOIN t_knsitsyo_set t2 
        ON t2.knsitsyo_id = t1.knsitsyo_id 
        AND (t2.del_flg is null or t2.del_flg = '0') 
    GROUP BY
      t1.knsitsyo_id
      , t2.knsitsyo_set_id