how to fetch multiple rows with same category id ?

[Ebadullahamini]

i have a VIEW and it joined with two tables. i want to read rows that some subject id. how can i do this?
example :
[
{
"id" : 1.
"name" : "book",
"category_id": 2
}
{
"id" : 1.
"name" : "book",
"category_id": 2
}
{
"id" : 1.
"name" : "nootbook",
"category_id": 1
}

]

i want to fetch rows with category id = 2

Please help

[MaxwellEnemuo]

You should query your database like below :

$data = "SELECT * FROM view_name WHERE category_id = 2";