add my in page list

hello , Hope everything is well with you
my question its that
i want to add sql select in list page with where
first i have in mysql this
(SELECT list.id_list, list.agent, list.date_d, list.n_comerce, list.nom_client FROM list)
But in list page i want have only data created by the user
(SELECT list.id_list, list.agent, list.date_d, list.n_comerce, list.nom_client FROM list Where list.agent = seesion.username)
Best Regards