MySQL 8.0

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

create table Books (id int, book_title varchar(50), book_author varchar(50), category varchar(50), product_status int)
insert into Books values (1, 'First title', 'Mark Markson', 'Nonfiction', 1)
insert into Books values (2, 'First title', 'Mark Markson', 'Biography', 1)
insert into Books values (3, 'Second title', 'Mark Anderson', 'SF', 1)
insert into Books values (4, 'Third title', 'Sam Markson', 'Biography', 0)
select  book_title, book_author, max(category)
from Books 
where product_status = '1'
group by  book_title, book_author;


book_title
book_author
max(category)


First title
Mark Markson
Nonfiction

Second title
Mark Anderson
SF

book_title	book_author	max(category)
First title	Mark Markson	Nonfiction
Second title	Mark Anderson	SF