MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE timetable (
  `id` INTEGER,
  `name` VARCHAR(13),
  `club` VARCHAR(8),
  `time` TIME
);

INSERT INTO timetable
  (`id`, `name`, `club`, `time`)
VALUES
  ('1', 'pero', 'name1', '12:11:01'),
  ('2', 'marko', 'name1', '12:14:02'),
  ('3', 'ante', 'name1', '12:18:05'),
  ('4', 'josipa', 'name1', '12:05:02'),
  ('5', 'iva', 'name1', '12:08:00'),
  ('6', 'vijeko', 'name2', '12:25:01'),
  ('7', 'alen', 'name2', '12:31:05'),
  ('8', 'antonia', 'name2', '12:14:08'),
  ('9', 'boris', 'name2', '12:15:19'),
  ('10', 'miro', 'name3', '12:17:20'),
  ('11', 'ines', 'name3', '12:18:20'),
  ('12', 'robert', 'name3', '12:33:11'),
  ('13', 'Ivana', 'name3', '12:08:00'),
  ('14', 'Ana', 'name3', '12:01:05');
SELECT
    `name`,
    tta.`club`,
	`time`,
    totaltime
FROM
	(
	SELECT
	`name`, `time`
	,IF(@club = `club`,@rnk := @rnk  + 1,@rnk := 1) rnk
	,@club := `club` `club`
	FROM
	(SELECT * FROM timetable ORDER BY club ASC,`time` ASC) tt, (SELECT @rnk := 0) a,(SELECT @club := '') b
	) tta 
  inner JOIN (
	SELECT 
	`club`,
	SEC_TO_TIME(SUM(TIME_TO_SEC(`time`))) as totaltime
	FROM (
	SELECT
	 `time`
	,IF(@club = `club`,@rnk := @rnk  + 1,@rnk := 1) rnk
	,@club := `club` `club`
	FROM
		(SELECT * FROM timetable ORDER BY club ASC,`time` ASC) tt, (SELECT @rnk := 0) a,(SELECT @club := '') b) ttb  
		WHERE rnk <= 3
		GROUP BY `club` 
		) ttb 
  ON tta.`club`  = ttb.`club`
WHERE tta.rnk <= 3


name
club
time
totaltime


iva
name1
12:08:00
36:24:03

pero
name1
12:11:01
36:24:03

josipa
name1
12:05:02
36:24:03

antonia
name2
12:14:08
36:54:28

boris
name2
12:15:19
36:54:28

vijeko
name2
12:25:01
36:54:28

Ana
name3
12:01:05
36:26:25

Ivana
name3
12:08:00
36:26:25

miro
name3
12:17:20
36:26:25

name	club	time	totaltime
iva	name1	12:08:00	36:24:03
pero	name1	12:11:01	36:24:03
josipa	name1	12:05:02	36:24:03
antonia	name2	12:14:08	36:54:28
boris	name2	12:15:19	36:54:28
vijeko	name2	12:25:01	36:54:28
Ana	name3	12:01:05	36:26:25
Ivana	name3	12:08:00	36:26:25
miro	name3	12:17:20	36:26:25