Filter By the two or more columns inside the same Relationship

[ahmedsayedabdelsalam]

I've this simple relationship (user) has many (posts)

and this is my posts table in DB

when i filter the users by posts.title and posts.is_published
here is the query

the returned result set is not correct
here is the result

which is wrong the user has two posts one is published but the name is not equal one and the other one name is correct equals one but is not published

here is the executed query

select
  id,
  name
from
  users
where
  exists (
    select
      *
    from
      posts
    where
      users.id = posts.user_id
      and posts.title = 'one'
  )
  and exists (
    select
      *
    from
      posts
    where
      users.id = posts.user_id
      and posts.is_published = 1
  )
limit
  15 offset 0

this issue here is that 2 separate where exists are executed and it is correct the same user has one or more posts published and one ore more records with name one

not as expected one exists clause with the the 2 conditions inside it

what i am trying to say here is there anyway or future plan for this situation ?
something like grouping the nested filter first then running one exists for each relation.

Thanks in advance.