SELECT p.id, p.sku, p.name, p.product_type, c.name as category_name, p.selling_price, p.cost_price, p.status, p.created_at 
   FROM products p 
   LEFT JOIN product_categories c ON p.category_id = c.id