Oracle 18c

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

create table person( id number, name varchar2(20));
begin
  insert into person(id, name) values (1,'Liam');
  insert into person(id, name) values (2,'Noah');
  insert into person(id, name) values (3,'Oliver');
  insert into person(id, name) values (4,'Elijah');
  insert into person(id, name) values (5,'William');
  insert into person(id, name) values (6,'James');
  insert into person(id, name) values (7,'Benjamin');
  insert into person(id, name) values (8,'Lucas');
  insert into person(id, name) values (9,'Henry');
  insert into person(id, name) values (10,'Alexande');
  insert into person(id, name) values (11,'Mason');
  insert into person(id, name) values (12,'Michael');
  insert into person(id, name) values (13,'Ethan');
  insert into person(id, name) values (14,'Daniel');
  insert into person(id, name) values (15,'Jacob');
  insert into person(id, name) values (16,'Logan');
  insert into person(id, name) values (17,'Jackson');
  insert into person(id, name) values (18,'Levi');
  insert into person(id, name) values (19,'Sebastia');
  insert into person(id, name) values (20,'Mateo');
end;
/
1 rows affected

create table friends( person number, friend number);
begin
  insert into friends (person, friend) values (1,2);
  insert into friends (person, friend) values (2,3);
  insert into friends (person, friend) values (3,4);
  insert into friends (person, friend) values (4,5);
  insert into friends (person, friend) values (2,6);
  insert into friends (person, friend) values (2,7);
  insert into friends (person, friend) values (3,8);
  insert into friends (person, friend) values (8,9);
  insert into friends (person, friend) values (4,10);
  insert into friends (person, friend) values (5,11);
  insert into friends (person, friend) values (5,12);
  insert into friends (person, friend) values (5,13);
  insert into friends (person, friend) values (6,14);
  insert into friends (person, friend) values (6,15);
  insert into friends (person, friend) values (7,16);
  insert into friends (person, friend) values (7,17);
  insert into friends (person, friend) values (7,18);
  insert into friends (person, friend) values (17,19);
  insert into friends (person, friend) values (18,20);
end;
/
1 rows affected

create table party(organizerid number, partydate date )
begin
  insert into party(organizerid, partydate ) values (1, date '2022-01-01');
  insert into party(organizerid, partydate ) values (2, date '2022-02-01');
  insert into party(organizerid, partydate ) values (3, date '2022-03-01');
  insert into party(organizerid, partydate ) values (5, date '2022-04-01');
  insert into party(organizerid, partydate ) values (6, date '2022-05-01');
  insert into party(organizerid, partydate ) values (7, date '2022-06-01');
end;
/
1 rows affected

alter session set nls_date_format = 'yyyy-mm-dd'
select pty.partydate, hq.*
from party pty
  left join lateral (
    select
      connect_by_root(f.person) as root,
      sys_connect_by_path(f.person, '/') as path,
      p.id,
      (p.name || ' is friend of ' || pf.name) as friendlink,
      f.person,
      f.friend
    from friends f
      join person p
        on f.person = p.id
      join person pf
        on f.friend = pf.id
    start with f.person = pty.organizerid
    connect by nocycle prior f.friend = f.person
  ) hq
    on pty.organizerid = hq.root
-- where pty.partydate = date '2022-03-01'
order by partydate, root, path


PARTYDATE
ROOT
PATH
ID
FRIENDLINK
PERSON
FRIEND


2022-01-01
1
/1
1
Liam is friend of Noah
1
2

2022-01-01
1
/1/2
2
Noah is friend of James
2
6

2022-01-01
1
/1/2
2
Noah is friend of Oliver
2
3

2022-01-01
1
/1/2
2
Noah is friend of Benjamin
2
7

2022-01-01
1
/1/2/3
3
Oliver is friend of Lucas
3
8

2022-01-01
1
/1/2/3
3
Oliver is friend of Elijah
3
4

2022-01-01
1
/1/2/3/4
4
Elijah is friend of William
4
5

2022-01-01
1
/1/2/3/4
4
Elijah is friend of Alexande
4
10

2022-01-01
1
/1/2/3/4/5
5
William is friend of Michael
5
12

2022-01-01
1
/1/2/3/4/5
5
William is friend of Mason
5
11

2022-01-01
1
/1/2/3/4/5
5
William is friend of Ethan
5
13

2022-01-01
1
/1/2/3/8
8
Lucas is friend of Henry
8
9

2022-01-01
1
/1/2/6
6
James is friend of Daniel
6
14

2022-01-01
1
/1/2/6
6
James is friend of Jacob
6
15

2022-01-01
1
/1/2/7
7
Benjamin is friend of Logan
7
16

2022-01-01
1
/1/2/7
7
Benjamin is friend of Levi
7
18

2022-01-01
1
/1/2/7
7
Benjamin is friend of Jackson
7
17

2022-01-01
1
/1/2/7/17
17
Jackson is friend of Sebastia
17
19

2022-01-01
1
/1/2/7/18
18
Levi is friend of Mateo
18
20

2022-02-01
2
/2
2
Noah is friend of Oliver
2
3

2022-02-01
2
/2
2
Noah is friend of James
2
6

2022-02-01
2
/2
2
Noah is friend of Benjamin
2
7

2022-02-01
2
/2/3
3
Oliver is friend of Elijah
3
4

2022-02-01
2
/2/3
3
Oliver is friend of Lucas
3
8

2022-02-01
2
/2/3/4
4
Elijah is friend of Alexande
4
10

2022-02-01
2
/2/3/4
4
Elijah is friend of William
4
5

2022-02-01
2
/2/3/4/5
5
William is friend of Ethan
5
13

2022-02-01
2
/2/3/4/5
5
William is friend of Michael
5
12

2022-02-01
2
/2/3/4/5
5
William is friend of Mason
5
11

2022-02-01
2
/2/3/8
8
Lucas is friend of Henry
8
9

2022-02-01
2
/2/6
6
James is friend of Jacob
6
15

2022-02-01
2
/2/6
6
James is friend of Daniel
6
14

2022-02-01
2
/2/7
7
Benjamin is friend of Jackson
7
17

2022-02-01
2
/2/7
7
Benjamin is friend of Logan
7
16

2022-02-01
2
/2/7
7
Benjamin is friend of Levi
7
18

2022-02-01
2
/2/7/17
17
Jackson is friend of Sebastia
17
19

2022-02-01
2
/2/7/18
18
Levi is friend of Mateo
18
20

2022-03-01
3
/3
3
Oliver is friend of Elijah
3
4

2022-03-01
3
/3
3
Oliver is friend of Lucas
3
8

2022-03-01
3
/3/4
4
Elijah is friend of Alexande
4
10

2022-03-01
3
/3/4
4
Elijah is friend of William
4
5

2022-03-01
3
/3/4/5
5
William is friend of Ethan
5
13

2022-03-01
3
/3/4/5
5
William is friend of Michael
5
12

2022-03-01
3
/3/4/5
5
William is friend of Mason
5
11

2022-03-01
3
/3/8
8
Lucas is friend of Henry
8
9

2022-04-01
5
/5
5
William is friend of Mason
5
11

2022-04-01
5
/5
5
William is friend of Michael
5
12

2022-04-01
5
/5
5
William is friend of Ethan
5
13

2022-05-01
6
/6
6
James is friend of Daniel
6
14

2022-05-01
6
/6
6
James is friend of Jacob
6
15

2022-06-01
7
/7
7
Benjamin is friend of Jackson
7
17

2022-06-01
7
/7
7
Benjamin is friend of Logan
7
16

2022-06-01
7
/7
7
Benjamin is friend of Levi
7
18

2022-06-01
7
/7/17
17
Jackson is friend of Sebastia
17
19

2022-06-01
7
/7/18
18
Levi is friend of Mateo
18
20

PARTYDATE	ROOT	PATH	ID	FRIENDLINK	PERSON	FRIEND
2022-01-01	1	/1	1	Liam is friend of Noah	1	2
2022-01-01	1	/1/2	2	Noah is friend of James	2	6
2022-01-01	1	/1/2	2	Noah is friend of Oliver	2	3
2022-01-01	1	/1/2	2	Noah is friend of Benjamin	2	7
2022-01-01	1	/1/2/3	3	Oliver is friend of Lucas	3	8
2022-01-01	1	/1/2/3	3	Oliver is friend of Elijah	3	4
2022-01-01	1	/1/2/3/4	4	Elijah is friend of William	4	5
2022-01-01	1	/1/2/3/4	4	Elijah is friend of Alexande	4	10
2022-01-01	1	/1/2/3/4/5	5	William is friend of Michael	5	12
2022-01-01	1	/1/2/3/4/5	5	William is friend of Mason	5	11
2022-01-01	1	/1/2/3/4/5	5	William is friend of Ethan	5	13
2022-01-01	1	/1/2/3/8	8	Lucas is friend of Henry	8	9
2022-01-01	1	/1/2/6	6	James is friend of Daniel	6	14
2022-01-01	1	/1/2/6	6	James is friend of Jacob	6	15
2022-01-01	1	/1/2/7	7	Benjamin is friend of Logan	7	16
2022-01-01	1	/1/2/7	7	Benjamin is friend of Levi	7	18
2022-01-01	1	/1/2/7	7	Benjamin is friend of Jackson	7	17
2022-01-01	1	/1/2/7/17	17	Jackson is friend of Sebastia	17	19
2022-01-01	1	/1/2/7/18	18	Levi is friend of Mateo	18	20
2022-02-01	2	/2	2	Noah is friend of Oliver	2	3
2022-02-01	2	/2	2	Noah is friend of James	2	6
2022-02-01	2	/2	2	Noah is friend of Benjamin	2	7
2022-02-01	2	/2/3	3	Oliver is friend of Elijah	3	4
2022-02-01	2	/2/3	3	Oliver is friend of Lucas	3	8
2022-02-01	2	/2/3/4	4	Elijah is friend of Alexande	4	10
2022-02-01	2	/2/3/4	4	Elijah is friend of William	4	5
2022-02-01	2	/2/3/4/5	5	William is friend of Ethan	5	13
2022-02-01	2	/2/3/4/5	5	William is friend of Michael	5	12
2022-02-01	2	/2/3/4/5	5	William is friend of Mason	5	11
2022-02-01	2	/2/3/8	8	Lucas is friend of Henry	8	9
2022-02-01	2	/2/6	6	James is friend of Jacob	6	15
2022-02-01	2	/2/6	6	James is friend of Daniel	6	14
2022-02-01	2	/2/7	7	Benjamin is friend of Jackson	7	17
2022-02-01	2	/2/7	7	Benjamin is friend of Logan	7	16
2022-02-01	2	/2/7	7	Benjamin is friend of Levi	7	18
2022-02-01	2	/2/7/17	17	Jackson is friend of Sebastia	17	19
2022-02-01	2	/2/7/18	18	Levi is friend of Mateo	18	20
2022-03-01	3	/3	3	Oliver is friend of Elijah	3	4
2022-03-01	3	/3	3	Oliver is friend of Lucas	3	8
2022-03-01	3	/3/4	4	Elijah is friend of Alexande	4	10
2022-03-01	3	/3/4	4	Elijah is friend of William	4	5
2022-03-01	3	/3/4/5	5	William is friend of Ethan	5	13
2022-03-01	3	/3/4/5	5	William is friend of Michael	5	12
2022-03-01	3	/3/4/5	5	William is friend of Mason	5	11
2022-03-01	3	/3/8	8	Lucas is friend of Henry	8	9
2022-04-01	5	/5	5	William is friend of Mason	5	11
2022-04-01	5	/5	5	William is friend of Michael	5	12
2022-04-01	5	/5	5	William is friend of Ethan	5	13
2022-05-01	6	/6	6	James is friend of Daniel	6	14
2022-05-01	6	/6	6	James is friend of Jacob	6	15
2022-06-01	7	/7	7	Benjamin is friend of Jackson	7	17
2022-06-01	7	/7	7	Benjamin is friend of Logan	7	16
2022-06-01	7	/7	7	Benjamin is friend of Levi	7	18
2022-06-01	7	/7/17	17	Jackson is friend of Sebastia	17	19
2022-06-01	7	/7/18	18	Levi is friend of Mateo	18	20