Self Join in Eloquent

Question

How would you write self-participation in eloquence? Do I need to define relationships on a model?

Here is my statement:

SELECT t2.title FROM products t1, products t2 WHERE t1.id = $id AND t2.color_id = t1.color_id AND t2.id != $id 

Answer 1

You can simply determine your attitude to yourself.

 public function parent() { return $this->belongsTo(self::class, 'color_id'); } public function children() { return $this->hasMany(self::class, 'color_id'); }