hello i have this tables
CREATE TABLE IF NOT EXISTS `categories` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`parent` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `categories` (`id`, `name`, `parent`) VALUES
(NULL, 'saman', 0),
(NULL, 'suzan', 0),
(NULL, 'saeed', 2),
(NULL, 'sadegh', 3);
and i want to show somthing like suzan>saeed>sadegh
with php and mysql
its just like wordpress category system but i dont know how to make that