MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();


version()


8.0.36


CREATE TABLE news_items (
  id integer,
  json_id VARCHAR(1000),
  data char(4)
  );

/*
id | json_id | data    |
|----|-----------------------------------------------------------------------------------------|---------|
| 991  | {'\160f7a4a-766a-4c23-a155-8bd3f7389f77\','\160f7a4a-766a-4c23-a155-8bd3f7389f77\'} | data 
*/
INSERT INTO news_items VALUES
  (991  , "{'\160f7a4a-766a-4c23-a155-8bd3f7389f77\','\160f7a4a-766a-4c23-a155-8bd3f7389f77\'}" , 'data');
CREATE TABLE kols (
  id integer,
  kol_id VARCHAR(100),
  name VARCHAR(20),
  data VARCHAR(100)
  );
INSERT INTO kols VALUES 
(1, '160f7a4a-766a-4c23-a155-8bd3f7389f77', 'balwant', 'data'),
(2, '63233bfc-b663-4c73-890b-00a48d79c4dc', 'vikram', 'data');

Records: 2  Duplicates: 0  Warnings: 0


SELECT *
FROM news_items;


id
json_id
data


991
{'160f7a4a-766a-4c23-a155-8bd3f7389f77','160f7a4a-766a-4c23-a155-8bd3f7389f77'}
data


SELECT DISTINCT k.*
FROM kols AS k
JOIN news_items AS n 
    ON FIND_IN_SET(k.kol_id, 
        REPLACE(REPLACE(REPLACE(json_id, '{', ''), '}', ''), "'", ''))


id
kol_id
name
data


1
160f7a4a-766a-4c23-a155-8bd3f7389f77
balwant
data