No stuff :(<pre>
		SELECT 
			a.*,
			b.catname,
			b.dayrate,
			b.weekrate,
			c.catname as pcatname
		FROM cs_mstprod a
		INNER JOIN cs_cdcat b 
		  ON a.catid 	= b.catid
		LEFT JOIN cs_cdcat c 
		  ON b.pcatid 	= c.catid 
		WHERE a.pid = '4'
		</pre>