Postgres 15

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table post_comment_response (id integer, post_comment_id integer, comment text, approval_status text);
insert into post_comment_response values
(1,	1173,	'Hello World',	NULL) ;

create table post_comment (id integer, post_id integer) ;
insert into post_comment values
(1173, 652) ;

create table post (id integer, message_id integer, team_member_id integer) ;
insert into post values
(652, 110, 60735) ;

create table team_member_manager (id integer, managing_team_member_id integer, managed_team_member_id integer) ;
insert into team_member_manager values
(55,	68893,	60735),
(56,	68893,	60736);

create table team_member (id integer, team_id integer, member_id integer) ;
insert into team_member values
(68893,	91,	1);

create table post_comment_response_approval (id integer, post_comment_response_id integer, team_member_id integer, approved boolean, note text) ;
insert into post_comment_response_approval values
(54,	1,	60735,	true,	'This one should be included'),
(70,	1,	666,	true,	'This should not'),
(70,	1,	60736,	false,	'This should be included');

CREATE TABLE

INSERT 0 1

CREATE TABLE

INSERT 0 1

CREATE TABLE

INSERT 0 1

CREATE TABLE

INSERT 0 2

CREATE TABLE

INSERT 0 1

CREATE TABLE

INSERT 0 3

WITH list AS (
SELECT 
       pcr.id, pcr.post_comment_id, pcr.comment
     , CASE WHEN COALESCE(bool_and(pcra.approved), true) THEN 'approve' WHEN NOT bool_and(pcra.approved) THEN 'reject' ELSE 'pending' END AS approval_status
  FROM post_comment_response pcr
  LEFT JOIN post_comment_response_approval pcra ON pcra.post_comment_response_id = pcr.id
  JOIN team_member_manager tmm ON tmm.managed_team_member_id = pcra.team_member_id
  JOIN team_member tm ON tm.id = tmm.managing_team_member_id
 WHERE pcr.post_comment_id = 1173
   AND tm.team_id = 91
  GROUP BY pcr.id, pcr.post_comment_id, pcr.comment
)
UPDATE post_comment_response pcr
   SET approval_status = l.approval_status
  FROM list l
 WHERE pcr.id = l.id ;

UPDATE 1

SELECT * FROM post_comment_response

id
post_comment_id
comment
approval_status

1
1173
Hello World
reject

SELECT 1

WITH list AS (
SELECT 
       pcr.id, pcr.post_comment_id, pcr.comment
     , CASE WHEN COALESCE(bool_and(pcra.approved), true) THEN 'approve' WHEN NOT bool_and(pcra.approved) THEN 'reject' ELSE 'pending' END AS approval_status
  FROM post_comment_response pcr
  LEFT JOIN post_comment_response_approval pcra ON pcra.post_comment_response_id = pcr.id
  JOIN team_member_manager tmm ON tmm.managed_team_member_id = pcra.team_member_id
  JOIN team_member tm ON tm.id = tmm.managing_team_member_id
  JOIN post_comment pc ON pc.id = pcr.post_comment_id
  JOIN post p ON p.id = pc.post_id
  JOIN team_member_manager tmm2 ON tmm2.managed_team_member_id = p.team_member_id AND tmm2.managing_team_member_id = tm.id
 GROUP BY pcr.id, pcr.post_comment_id, pcr.comment
)
UPDATE post_comment_response pcr
   SET approval_status = l.approval_status
  FROM list l
 WHERE pcr.id = l.id ;

UPDATE 1

SELECT * FROM post_comment_response

id
post_comment_id
comment
approval_status

1
1173
Hello World
reject

SELECT 1