SELECT 
0 language_id,
p.product_id products_id,
c.category_id categories_id,
category_parent_id parent_id,
0 sort_order,
c.category_name categories_name 
from <@PREFIX>hikashop_product_category p join <@PREFIX>hikashop_category c on 
(p.category_id = c.category_id) 
