Create a complex query

+---------+-----+-----+---------+ | tree_id | lft | rgt | name | +---------+-----+-----+---------+ | 1 | 1 | 138 | TV's | | 2 | 2 | 91 | Phones | | 3 | 3 | 26 | Samsung | | 4 | 4 | 10 | Used | | 5 | 11 | 25 | New | | 6 | 27 | 45 | Apple | | 7 | 46 | 90 | Philips | | 8 | 47 | 51 | Touch | | 9 | 52 | 89 | Key | | | | | | +---------+-----+-----+---------+ +------------+-------------+-------+ | product_id | Name | make | +------------+-------------+-------+ | 1 | Touch Easy | 4466 | | 2 | Eagle Eye | 5523 | | 3 | Super Phone | 7Utt | | 4 | Crazy Touch | Utiir | +------------+-------------+-------+ +------------+--------+ | product_id | cat_id | +------------+--------+ | 1 | 5 | | 2 | 8 | | 3 | 2 | | 4 | 3 | +------------+--------+ More info [login to view URL]