SELECT 
0 language_id,
p.productid products_id,
productcategoryid categories_id,
0 parent_id,
'' categories_image,
productcategoryid sort_order,
p.productcategory categories_name from 
vtiger_productcategory a join vtiger_products p on 
 p.productcategory = a.productcategory