Categories:
cat_id
parent_id
name
description
icon_url

This table manages my categories. Each category will point to a parent category unless it is on the top tier where parent_id = 0.

When I do a fetchAll(); I obviously get just a int for "parent_id". How can I change that into the associated name column?

cat_id, parent_id, name, description
0, 0, Top Level, NULL
1, 0, Animals, NULL
2, 1, Cats, NULL
3, 1, Dogs, NULL
4, 3, Jack Russell, NULL

I want to say that the category "Jack Russell" points to "Dogs" not 3.

Hope it makes sense, it's quite hard to explain.

Many thanks.

Can anyone help me construct this query? In ad hoc php/ html programming I've had a query within a result loop. I'm sure it must be easier than this.

Any advice would be gratefully received.