This question already has an answer here:
I have the table tbl_relations with columns
id,user_name,relation_name,relation_name_id
relation_name_id is the foreign key referencing id in the same table.
In laravel I will select two inputs from id and need to get the collections of data from input one to till it's reach the second input using foreign key recursive method..is it possible?
This way I need to get the collection
This solution is probably inefficient but it will work:
class Relation extends Model {
protected $table = 'tbl_relations';
protected $with = [ 'related' ];
public function related() {
return $this->hasOne(Relation::class, 'relation_name_id');
}
}
Each time the Relation model is loaded it should trigger a loading of the related relation.
You can then do:
Relation::find(1)->related->related->id;
Note this solution does not take into account specific MySQL optimizations so will probably be the slowest possible solution.
如果觉得我的文章对您有用，请随意打赏。你的支持将鼓励我继续创作！
