app\models\Tournament::getRegistrationStage PHP Method

    public static function getRegistrationStage()
    {
        return self::query()->where('signup_open', '<', Carbon::now())->where('signup_close', '>', Carbon::now())->orderBy('play_mode', 'desc')->orderBy('tournament_id', 'desc')->get();
    }

 public function index()
 {
     return view('tournaments.index')->with('tournaments', Tournament::getRegistrationStage());
 }