package MyDB::ForeignTable;

#....

__PACKAGE__->has_many( 'selfs' => 'MyDB::SelfTable', {"foreign.fid" => "self.id"});