php - Laravel join query with json data -

i have products id in json format in sales table. want fetch data , need join products table product details such product name, product image,etc

here sample data sales table , orders column

[{"pcode":"r1160","qty":1,"price":"270","default_shipping":30}, {"pcode":"r1112","qty":1,"price":"250","default_shipping":30}] 

now want join query products table , want products details