RLS How to read using join on column value?

CREATE TABLE rooms (
    id integer GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    user_id_one uuid NOT NULL REFERENCES users(user_id) ON DELETE CASCADE,
    user_id_two uuid NOT NULL REFERENCES users(user_id) ON DELETE CASCADE
);

CREATE TABLE messages (
    id integer GENERATED ALWAYS AS IDENTITY PRIMARY KEY,
    from_user_id uuid NOT NULL REFERENCES users(user_id) ON DELETE CASCADE,
    message text NOT NULL,
    room_id integer NOT NULL REFERENCES rooms(id) ON DELETE CASCADE,
    create_time timestamp with time zone NOT NULL DEFAULT now(),
    message_id uuid NOT NULL UNIQUE
);

SELECT m.room_id
 FROM messages m
          JOIN rooms r ON r.id = m.room_id
 WHERE user_id_one = '8dd172ba-7cfc-4c43-a427-601e505709f6'
    OR user_id_two = '8dd172ba-7cfc-4c43-a427-601e505709f6'

CREATE FUNCTION get_rooms_with_user_id(p_user_id uuid)