Unknown column 'b.product_name_pr' in 'field list'
SELECT `a`.`id`,`a`.`category_name_tw`,`a`.`category_name_en`, `b`.`id` AS `product_id`,`b`.`category_id`,`b`.`product_name_pr` AS `product_name` FROM `categorys` AS `a` LEFT JOIN `products` AS `b` ON `b`.`category_id`=`a`.`id` AND `b`.`status`=1 WHERE `a`.`status`=1 ORDER BY `a`.`sort_id`,`b`.`category_id`,`b`.`sort_id`