Here I have created sample that will help you out.

Please refer below article to get SplitString Function

Split and convert Comma Separated (Delimited) String to Table in SQL Server

SQL

SELECT * FROM FruitTable
SELECT * FROM SecondTable

DECLARE @PersonId INT
SET @PersonId = 1

DECLARE @FruitIds VARCHAR(50)
SELECT  @FruitIds = FruitId FROM SecondTable WHERE Id = @PersonId

SELECT  @PersonId as 'Id',STUFF((SELECT ',' + Fruit FROM 
				(
					SELECT  CONVERT(VARCHAR,@PersonId) as PersonId,* FROM FruitTable WHERE Id IN (SELECT CAST(id AS INTEGER)
																							FROM dbo.SplitString(@FruitIds, ','))
				) as childTable
WHERE  mainTable.PersonId= childTable.PersonId
FOR XML PATH('')), 1, 1, '') AS Fruitname,
REPLACE(SUM(CAST(REPLACE(Price,',','.') AS DECIMAL(18,2))),'.',',') AS 'Summa price'			
FROM 
(
	SELECT CONVERT(VARCHAR,@PersonId) as PersonId,* FROM FruitTable WHERE Id IN (SELECT CAST(id AS INTEGER)
																		   FROM dbo.SplitString(@FruitIds, ','))
) as mainTable
GROUP BY mainTable.PersonId

Screenshot