insert with multiple row return through select
Almost. You need to remove the values clause and just put the select straight after the table and column names of the insert clause:

INSERT INTO notifications(text, uid, read_status)
SELECT "abc", uid, 0 FROM users WHERE status = 1;


Then the output of the select will go to the insert.