ifnews/app/Models/Tag.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use App\Models\Language;
use App\Models\Game;

class Tag extends Model
{
  public $timestamps = false;
	public function language() {
		return $this->belongsTo(Language::class);
	}

	public function games() {
		return $this->belongsToMany(Game::class, 'tags_games');
  }

  /**
   * @param string $name
   * @param int|Language $language
   */
  public static function findByName($name, $language) {
    $language_id = NULL;
    if ($language instanceof Language) {
      $language_id = $language->id;
    }
    if (is_int($language)) {
      $language_id = $language;
    }
    return self::whereRaw('LOWER(title) = ?', mb_strtolower($name))
      ->where('language_id', $language_id)
      ->first();
  }
}