MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table `user`
(
  `id` int,
  `username` varchar(20),
  `password` varchar(20),
  `status` varchar(20)
)
insert into `user` (`id`,`username`,`password`,`status`) values
(1,   'Prajna',    '*****',     'active'),
(2,   'Akshata',   '*****',     'active'),
(3,   'Sanjana',   '*****',     'inactive')
create table `test`
(
  `id` int,
  `project_name` varchar(20),
  `created_by` int,
  `edited_by` int
)
insert into `test` (`id`,`project_name`,`created_by`,`edited_by`) values
(1,   'Test',   1,     2),
(2,   'Trial',  1,     1),
(3,   'Pro1',   2,     2)
SELECT
  `t`.`project_name`, 
  `ua`.`username` as 'username (created by)' , 
  `ub`.`username` as 'username (edited by)' 
FROM `test` `t` 
  JOIN `user` `ua` ON `t`.`created_by` = `ua`.`id` 
  JOIN `user` `ub` ON `t`.`edited_by` = `ub`.`id`
WHERE 
 `ua`.`status` = 'active' 
  AND `ub`.`status` = 'active'
order by `t`.`id`


project_name
username (created by)
username (edited by)


Test
Prajna
Akshata

Trial
Prajna
Prajna

Pro1
Akshata
Akshata