CREATE TABLE `Elements` (
	`genre_id` SMALLINT(3) UNSIGNED NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(60) NOT NULL,
	`type` ENUM('type','form','genre','subgenre') NULL DEFAULT 'type',
	`disc` VARCHAR(60) NOT NULL,
	PRIMARY KEY (`genre_id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=33

CREATE TABLE `ElementHierarchy` (
	`genre_id` SMALLINT(3) UNSIGNED NOT NULL,
	`parent_id` SMALLINT(3) UNSIGNED NULL DEFAULT NULL,
	`level` TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
	INDEX `FK_ElementsHierarchy_Elements` (`parent_id`),
	INDEX `FK_ElementsHierarchy_Elements_2` (`genre_id`),
	CONSTRAINT `FK_ElementsHierarchy_Elements` FOREIGN KEY (`parent_id`) REFERENCES `Elements` (`genre_id`),
	CONSTRAINT `FK_ElementsHierarchy_Elements_2` FOREIGN KEY (`genre_id`) REFERENCES `Elements` (`genre_id`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB

SELECT Elements.*, Parent.ParentID FROM Elements

INNER JOIN ElementsHierarchy as Hier
        ON Hier.ElemID = Elements.ID

INNER JOIN ElementsHierarchy as Parent
        ON Parent.ElemID = Elements.ID

WHERE Hier.ParentID = 24