self referencing tables

hey there,

i have a table $artists, which i want to self reference through another table $inspirations

$artists has many $inspirations.

but $inspirations are actually just different $artists.

$inspirations would have:

artist_id -> as per a standard has->many relation

but now i want to point it back to itself, eg:

inspiration_artist_id is actually pointing back to the $artists table.

any ideas how i would go about this?

thanks in advance




//relation

'artistsList'=>array(self::MANY_MANY,'Artists','inspirations(inspiration_artist_id,artist_id)')