SELECT *
FROM users
CROSS JOIN JSON_TABLE(campaigns_list, ‘$[*]’ COLUMNS (
campaign_name varchar(100) PATH ‘$.campaign_name’,
campaign_id varchar(100) PATH ‘$.campaign_id’
)
) AS j
WHERE campaign_name IN(‘cam4′,’cam1’);

this is the sql query which is working.

I have got this sql solution for my application but not able to get it in active record.