By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `seasons` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`year` int(11) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
CREATE TABLE `seasons_weeks` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`week_number` tinyint(4) NOT NULL,
`season_id` bigint(20) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `seasons_weeks_season_id_foreign` (`season_id`),
CONSTRAINT `seasons_weeks_season_id_foreign` FOREIGN KEY (`season_id`) REFERENCES `seasons` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
CREATE TABLE `matches` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`title` json NOT NULL,
`description` json NOT NULL,
`image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`video` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`week_id` bigint(20) unsigned NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `matches_week_id_foreign` (`week_id`),
CONSTRAINT `matches_week_id_foreign` FOREIGN KEY (`week_id`) REFERENCES `seasons_weeks` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
SELECT m.id,s.`year`
FROM matches m
INNER JOIN seasons_weeks sw ON m.week_id = sw.id
INNER JOIN seasons s ON sw.season_id = s.id